Khurram Faraaz created DRILL-4862: ------------------------------------- Summary: wrong results - use of convert_from(binary_string(key),'UTF8') in filter results in wrong results Key: DRILL-4862 URL: https://issues.apache.org/jira/browse/DRILL-4862 Project: Apache Drill Issue Type: Bug Components: Execution - Flow Affects Versions: 1.8.0 Environment: 4 node cluster CentOS Reporter: Khurram Faraaz
These results do not look right, i.e when the predicate has convert_from(binary_string(key),'UTF8') Apache drill 1.8.0-SNAPSHOT git commit ID: 57dc9f43 {noformat} [root@centos-0x drill4478]# cat f1.json {"key":"\\x30\\x31\\x32\\x33"} {"key":"\\x34\\x35\\x36\\x37"} {"key":"\\x38\\x39\\x30\\x31"} {"key":"\\x30\\x30\\x30\\x30"} {"key":"\\x31\\x31\\x31\\x31"} {"key":"\\x35\\x35\\x35\\x35"} {"key":"\\x38\\x38\\x38\\x38"} {"key":"\\x39\\x39\\x39\\x39"} {"key":"\\x41\\x42\\x43\\x44"} {"key":"\\x45\\x46\\x47\\x48"} {"key":"\\x49\\x41\\x44\\x46"} {"key":"\\x4a\\x4b\\x4c\\x4d"} {"key":"\\x57\\x58\\x59\\x5a"} {"key":"\\x4e\\x4f\\x50\\x51"} {"key":"\\x46\\x46\\x46\\x46"} {noformat} results without the predicate - these are correct results {noformat} 0: jdbc:drill:schema=dfs.tmp> select convert_from(binary_string(key),'UTF8') from `f1.json`; +---------+ | EXPR$0 | +---------+ | 0123 | | 4567 | | 8901 | | 0000 | | 1111 | | 5555 | | 8888 | | 9999 | | ABCD | | EFGH | | IADF | | JKLM | | WXYZ | | NOPQ | | FFFF | +---------+ 15 rows selected (0.256 seconds) {noformat} results with a predicate - these results don't look correct {noformat} 0: jdbc:drill:schema=dfs.tmp> select convert_from(binary_string(key),'UTF8') from `f1.json` where convert_from(binary_string(key),'UTF8') is not null; +----------+ | EXPR$0 | +----------+ | 0123123 | | 4567567 | | 8901901 | | 0000000 | | 1111111 | | 5555555 | | 8888888 | | 9999999 | | ABCDBCD | | EFGHFGH | | IADFADF | | JKLMKLM | | WXYZXYZ | | NOPQOPQ | | FFFFFFF | +----------+ 15 rows selected (0.279 seconds) {noformat} -- This message was sent by Atlassian JIRA (v6.3.4#6332)