About casey

casey · ‎06-21-2016

Unfortunately there doesn't seem to be a function that does this. If you are familiar with Java or C++, writing a UDF shouldn't be too hard. UDF documentation is at http://www.cloudera.com/documentation/enterprise/latest/topics/impala_udf.html and of course if you have questions we can help you here.

casey · ‎06-20-2016

Hello, Impala implemented this function for Hive compatibility. The behavior is the same is in Hive. I'm not sure why Hive decided to implement the function this way. The input "4B" is converted to a character using the same logic as shown in http://www.asciitable.com/, you'll see "4B" corresponds to the character "K" (column "Hx" to column "Chr"). In the "4B" case, the ASCII() function can be used to give the value you expected. Query: select ascii(unhex('4b')) +--------------------+ | ascii(unhex('4b')) | +--------------------+ | 75 | +--------------------+

casey · ‎12-09-2015

Hi Jais, The error appears to come from the Simba's JDBC driver code instead of Impala. You might try contacting Simba for help. Also the driver has a native mode, enabling the UseNativeQuery option may help by bypassing some driver side processing. If you see any errors in the impalad or catalogd logs please post them. Or if you have a consistent way to reproduce the error, we can work with Simba on the problem. Casey

Online	Offline
Last Visited	‎06-21-2016 03:15 PM

Member Since	‎12-08-2015 12:06 PM
Last Visited	‎06-21-2016 03:15 PM
Posts	10

Cloudera Community

Re: unhex in Impala

Re: unhex in Impala

Re: unhex in Impala

Re: [Simba][ImpalaJDBCDriver](500051) The table "...