Below are the two examples where 'like' and 'not like' operator on
data(specially xml type data) not working properly.
------------------------------------------Example with like
-------------------------------------------
0: jdbc:drill:> select * , (ajaxResponse like '%xml version%') from tt1 ;
+-----------+-------+--------------+--------+
| sessionid | event | ajaxResponse | EXPR$1 |
+-----------+-------+--------------+--------+
| DA6CC0BF2BE1499C28AB1E2 | event.ajax | null | null |
| DA6CC0BF2BE1499C28AB1E2 | gtm.load | null | null |
| DA6CC0BF2BE1499C28AB1E2 | event.ajax | <?xml version="1.0"
encoding="UTF-8"?>
<!-- -->
<root>
<!-- -->
<winningPath>0</winningPath>
<paths>
<path>
<filePath>Cash/addCash_pat | false |
+-----------+-------+--------------+--------+
3 rows selected (0.202 seconds)
------------------------------------------Example with not like
-------------------------------------------
0: jdbc:drill:> select * , (ajaxResponse not like '%xml version%') from tt1
;
+-----------+-------+--------------+--------+
| sessionid | event | ajaxResponse | EXPR$1 |
+-----------+-------+--------------+--------+
| DA6CC0BF2BE1499C28AB1E2 | event.ajax | null | null |
| DA6CC0BF2BE1499C28AB1E2 | gtm.load | null | null |
| DA6CC0BF2BE1499C28AB1E2 | event.ajax | <?xml version="1.0"
encoding="UTF-8"?>
<!-- -->
<root>
<!-- -->
<winningPath>0</winningPath>
<paths>
<path>
<filePath>Cash/addCash_pat | true |
+-----------+-------+--------------+--------+
3 rows selected (0.109 seconds)
0: jdbc:drill:>
Regards,
Pratik K.
|