[ https://issues.apache.org/jira/browse/HIVE-24877?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Naresh P R updated HIVE-24877: ------------------------------ Description: Hive is currently not supporting following syntax select x'abc'; {code:java} org.apache.hadoop.hive.ql.parse.ParseException: line 2:8 cannot recognize input near 'x' ''abc'' '<EOF>' in selection target at org.apache.hadoop.hive.ql.parse.ParseDriver.parse(ParseDriver.java:125) at org.apache.hadoop.hive.ql.parse.ParseUtils.parse(ParseUtils.java:93) at org.apache.hadoop.hive.ql.parse.ParseUtils.parse(ParseUtils.java:85) at org.apache.hadoop.hive.ql.Compiler.parse(Compiler.java:169) at org.apache.hadoop.hive.ql.Compiler.compile(Compiler.java:102) at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:492) at org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:445){code} Though we have same via hex/unhex built-in UDF's, it's better to have {{X'value'}} and x'{{value'}} syntax support for Hive. [https://spark.apache.org/docs/latest/sql-ref-literals.html#binary-literal] [https://dev.mysql.com/doc/refman/8.0/en/string-functions.html#function_hex] [https://mariadb.com/kb/en/hexadecimal-literals/] was: Hive is currently not supporting following syntax select x'abc'; {code:java} org.apache.hadoop.hive.ql.parse.ParseException: line 2:8 cannot recognize input near 'x' ''abc'' '<EOF>' in selection targetorg.apache.hadoop.hive.ql.parse.ParseException: line 2:8 cannot recognize input near 'x' ''abc'' '<EOF>' in selection target at org.apache.hadoop.hive.ql.parse.ParseDriver.parse(ParseDriver.java:125) at org.apache.hadoop.hive.ql.parse.ParseUtils.parse(ParseUtils.java:93) at org.apache.hadoop.hive.ql.parse.ParseUtils.parse(ParseUtils.java:85) at org.apache.hadoop.hive.ql.Compiler.parse(Compiler.java:169) at org.apache.hadoop.hive.ql.Compiler.compile(Compiler.java:102) at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:492) at org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:445){code} Though we have same via hex/unhex built-in UDF's, it's better to have {{X'value'}} and x'{{value'}} syntax support for Hive. [https://spark.apache.org/docs/latest/sql-ref-literals.html#binary-literal] [https://dev.mysql.com/doc/refman/8.0/en/string-functions.html#function_hex] [https://mariadb.com/kb/en/hexadecimal-literals/] > Support X'xxxx' syntax for hexadecimal values like spark & mysql > ---------------------------------------------------------------- > > Key: HIVE-24877 > URL: https://issues.apache.org/jira/browse/HIVE-24877 > Project: Hive > Issue Type: New Feature > Reporter: Naresh P R > Priority: Minor > > Hive is currently not supporting following syntax > select x'abc'; > {code:java} > org.apache.hadoop.hive.ql.parse.ParseException: line 2:8 cannot recognize > input near 'x' ''abc'' '<EOF>' in selection target > at org.apache.hadoop.hive.ql.parse.ParseDriver.parse(ParseDriver.java:125) > at org.apache.hadoop.hive.ql.parse.ParseUtils.parse(ParseUtils.java:93) > at org.apache.hadoop.hive.ql.parse.ParseUtils.parse(ParseUtils.java:85) > at org.apache.hadoop.hive.ql.Compiler.parse(Compiler.java:169) > at org.apache.hadoop.hive.ql.Compiler.compile(Compiler.java:102) > at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:492) > at org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:445){code} > Though we have same via hex/unhex built-in UDF's, it's better to have > {{X'value'}} and x'{{value'}} syntax support for Hive. > [https://spark.apache.org/docs/latest/sql-ref-literals.html#binary-literal] > [https://dev.mysql.com/doc/refman/8.0/en/string-functions.html#function_hex] > [https://mariadb.com/kb/en/hexadecimal-literals/] -- This message was sent by Atlassian Jira (v8.3.4#803005)