Getting unexpected output in lingual shell while applying LIKE operator
27 views
Skip to first unread message
Amiya Mishra
Jul 18, 2016, 9:14:38 AM7/18/16
to Lingual User
Hi,
I had performed test on below data set through lingual shell and getting unexpected output:
+----------------+-------------+-------------+--------+--------+--------+-------------+
| f1 | f2 | f3 | f4 | f5 | f6 | f7 |
+----------------+-------------+-------------+--------+--------+--------+-------------+
| A...@gmail.com | 2014-02-06 | 2015-02-06 | 12.12 | true | true | 234432.234 |
| BBB@ymail_com | 2015-03-09 | 2010-02-06 | 12.12 | false | false | 10.34 |
| C...@google.in | 2014-05-19 | 2011-02-06 | 12.12 | false | true | 234.234 |
| D...@EEE.net | 2005-02-09 | 2014-02-06 | 12.12 | true | false | 2343.234 |
+----------------+-------------+-------------+--------+--------+--------+-------------+
Below are five cases i have tested above data with different query conditions:
CASE1:
jdbc:lingual:hadoop2-mr1> select * from "lingualquerycheck"."lingualqueryTable" where "f1" is not null and "f1" like '%@%_%';
Expected output:
+----------------+-------------+-------------+--------+--------+--------+-------------+
| f1 | f2 | f3 | f4 | f5 | f6 | f7 |
+----------------+-------------+-------------+--------+--------+--------+-------------+
| BBB@ymail_com | 2015-03-09 | 2010-02-06 | 12.12 | false | false | 10.34 |
Actual output getting:
+----------------+-------------+-------------+--------+--------+--------+-------------+
| f1 | f2 | f3 | f4 | f5 | f6 | f7 |
+----------------+-------------+-------------+--------+--------+--------+-------------+
| A...@gmail.com | 2014-02-06 | 2015-02-06 | 12.12 | true | true | 234432.234 |
| BBB@ymail_com | 2015-03-09 | 2010-02-06 | 12.12 | false | false | 10.34 |
| C...@google.in | 2014-05-19 | 2011-02-06 | 12.12 | false | true | 234.234 |
| D...@EEE.net | 2005-02-09 | 2014-02-06 | 12.12 | true | false | 2343.234 |
+----------------+-------------+-------------+--------+--------+--------+-------------+
CASE2:
jdbc:lingual:hadoop2-mr1> select * from "lingualquerycheck"."lingualqueryTable" where "f1" is not null and "f1" like '%@%.';
Expected output:
+-----+-----+-----+-----+-----+-----+-----+
| f1 | f2 | f3 | f4 | f5 | f6 | f7 |
+-----+-----+-----+-----+-----+-----+-----+
+-----+-----+-----+-----+-----+-----+-----+
Actual output getting:
+----------------+-------------+-------------+--------+--------+--------+-------------+
| f1 | f2 | f3 | f4 | f5 | f6 | f7 |
+----------------+-------------+-------------+--------+--------+--------+-------------+
| A...@gmail.com | 2014-02-06 | 2015-02-06 | 12.12 | true | true | 234432.234 |
| BBB@ymail_com | 2015-03-09 | 2010-02-06 | 12.12 | false | false | 10.34 |
| C...@google.in | 2014-05-19 | 2011-02-06 | 12.12 | false | true | 234.234 |
| D...@EEE.net | 2005-02-09 | 2014-02-06 | 12.12 | true | false | 2343.234 |
+----------------+-------------+-------------+--------+--------+--------+-------------+
CASE3:
jdbc:lingual:hadoop2-mr1> select * from "lingualquerycheck"."lingualqueryTable" where "f1" is not null and "f1" like '%@%_c%';
Expected output should be:
+----------------+-------------+-------------+--------+--------+--------+-------------+
| f1 | f2 | f3 | f4 | f5 | f6 | f7 |
+----------------+-------------+-------------+--------+--------+--------+-------------+
| BBB@ymail_com | 2015-03-09 | 2010-02-06 | 12.12 | false | false | 10.34 |
Actual output getting:
+----------------+-------------+-------------+--------+--------+--------+-------------+
| f1 | f2 | f3 | f4 | f5 | f6 | f7 |
+----------------+-------------+-------------+--------+--------+--------+-------------+
| A...@gmail.com | 2014-02-06 | 2015-02-06 | 12.12 | true | true | 234432.234 |
| BBB@ymail_com | 2015-03-09 | 2010-02-06 | 12.12 | false | false | 10.34 |
+----------------+-------------+-------------+--------+--------+--------+-------------+
CASE4:
jdbc:lingual:hadoop2-mr1> select * from "lingualquerycheck"."lingualqueryTable" where "f1" is not null and "f1" like '%@%.c%';
Expected output:
+----------------+-------------+-------------+--------+--------+--------+-------------+
| f1 | f2 | f3 | f4 | f5 | f6 | f7 |
+----------------+-------------+-------------+--------+--------+--------+-------------+
| A...@gmail.com | 2014-02-06 | 2015-02-06 | 12.12 | true | true | 234432.234 |
Actual output:
+----------------+-------------+-------------+--------+--------+--------+-------------+
| f1 | f2 | f3 | f4 | f5 | f6 | f7 |
+----------------+-------------+-------------+--------+--------+--------+-------------+
| A...@gmail.com | 2014-02-06 | 2015-02-06 | 12.12 | true | true | 234432.234 |
| BBB@ymail_com | 2015-03-09 | 2010-02-06 | 12.12 | false | false | 10.34 |
+----------------+-------------+-------------+--------+--------+--------+-------------+
CASE5:
jdbc:lingual:hadoop2-mr1> select * from "lingualquerycheck"."lingualqueryTable" where "f1" is not null and "f1" like '%@%.%';
Expected output:
+----------------+-------------+-------------+--------+--------+--------+-------------+
| f1 | f2 | f3 | f4 | f5 | f6 | f7 |
+----------------+-------------+-------------+--------+--------+--------+-------------+
| A...@gmail.com | 2014-02-06 | 2015-02-06 | 12.12 | true | true | 234432.234 |
| C...@google.in | 2014-05-19 | 2011-02-06 | 12.12 | false | true | 234.234 |
| D...@EEE.net | 2005-02-09 | 2014-02-06 | 12.12 | true | false | 2343.234 |
Actual output getting:
+----------------+-------------+-------------+--------+--------+--------+-------------+
| f1 | f2 | f3 | f4 | f5 | f6 | f7 |
+----------------+-------------+-------------+--------+--------+--------+-------------+
| A...@gmail.com | 2014-02-06 | 2015-02-06 | 12.12 | true | true | 234432.234 |
| BBB@ymail_com | 2015-03-09 | 2010-02-06 | 12.12 | false | false | 10.34 |
| C...@google.in | 2014-05-19 | 2011-02-06 | 12.12 | false | true | 234.234 |
| D...@EEE.net | 2005-02-09 | 2014-02-06 | 12.12 | true | false | 2343.234 |
+----------------+-------------+-------------+--------+--------+--------+-------------+
Considering above 5 cases i found that operator '.' has taken as any char value.
I have used below versions :
Lingual : 1.2.1
Hadoop : 2.6.0
Can somebody help me out from this ?
Thanks
Amiya Mishra
Reply all
Reply to author
Forward
0 new messages