drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Pratik Khedkar <pratik.khed...@games24x7.com>
Subject 'like' and 'not like' operator on data(specially xml type data) not working properly
Date Wed, 11 May 2016 13:15:00 GMT
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.

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message