Hive Runtime Error: Unable to deserialize reduce input key from...

Hi, I have two hive (0.13) tables with the following create syntax: CREATE TABLE `src`( `a` string, `b` int, `c` int, `p` string ); CREATE TABLE `tgt`( `a` string, `b` int, `c` int )PARTITIONED BY (`p` string); And the table src contains only one row : hive select * from src; OK

Re: Load CSV files with embedded map and arrays to Hive

Hey sorry .. got stuck with work. I will take a look today On Wed, Aug 20, 2014 at 5:43 PM, Sushant Prusty sushan...@gmx.com wrote: Hi Nitin, Hope you have received the dataset. If you have any further requirement, please feel free to contact. Will appreciate your help. Regards, Sushant

Re: New lines causing new rows

I have fixed this - I was using the wrong character to replace line breaks. I was replacing \r when it needed to be \n. Regards, Charles On 18 August 2014 08:44, Charles Robertson charles.robert...@gmail.com wrote: Hi Andre, Table and view definitions: CREATE EXTERNAL TABLE tweets_raw (

Re: change column type of orc table will throw exception in query time

hi all: I test the above example with hive trunk and it still fail. After some debugging, finally I find the cause of the problem: Hive use CombineFileRecordReader and in one CombineFileSplit there are often more than one path. In this case, the schema for these two paths (dt='20140718' vs

Denormalizing JSON arrays

Hey guys How do I denormalize the JSON arrays with a select statement ? Thanks Warm Regards sanjay DDL === USE sansub01 ; ADD JAR ./json-serde-1.3-SNAPSHOT-jar-with-dependencies.jar ; DROP TABLE IF EXISTS res_score ; CREATE EXTERNAL TABLE res_score (

Re: Denormalizing JSON arrays

Ok guys Figured it out Looks like the collective Hive Groups positive thought waves are helping me immensely – LOL After many experiments , this is the HQL that worked beautifully . I had forgotten that explode can take an array as a param as well ! HIVE QUERY == use sansub01 ;