You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@drill.apache.org by Pratik Khedkar <pr...@games24x7.com> on 2016/05/11 13:15:00 UTC

'like' and 'not like' operator on data(specially xml type data) not working properly

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.