Hive Update : Null Pointer Exception while using If statement

Hi Experts, I have table in hive in which i have to update certain records. I am using hive 0.13 version. I did bit of googling and found that i can use If-Else statement with insert overwrite for doing this but after running a query it is throwing null pointer exception. Here is my Employee tabl

RE: im having an issue extracting some data from json within hive in hdinsight

You probably want to be using the UDF get_json_object(), I added to this stackoverflow post [http://stackoverflow.com/questions/24447428/parse-json-arrays-using-hive] a few months agothe problem was specific to top-level JSON arrays, and is related to JIRA HIVE-1575 [https://issues.apache.or

im having an issue extracting some data from json within hive in hdinsight

and i wonder if this audience could help me out in any way. Here is a link to the request i put out on StackOverflow. I need help retrieving sub arrays from JSON with a HIVE query |   | |   | |   |   |   |   |   | | I need help retrieving sub arrays from JSON with a HIVE ...I have the following

Re: Unsigned Data Type Support

No, we don't natively support this in Hive. Alan. saurabh July 23, 2015 at 3:27 Hi All, Is there any data type in hive which only stores positive values and converts the negative values to ZERO? This can be handled while data processing e.g. CASE statement o

Unsigned Data Type Support

Hi All, Is there any data type in hive which only stores positive values and converts the negative values to ZERO? This can be handled while data processing e.g. CASE statement or COLEASCE(IF()), just wanted to be check if this can be handled at the Table definition level. Thanks in Advance. Re