NPE when running a Hive query with storage in S3

2014-08-18 Thread Ravuri, Venkata Puneet
Hi, I am using a Hadoop 2.4.1 + Hive 0.13 setup. I have a non-partitioned table whose storage location is S3. Its schema information:- SerDe Library: org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe InputFormat: org.apache.hadoop.hive.ql.io.RCFileInputF

Re: New lines causing new rows

2014-08-18 Thread Charles Robertson
Hi Andre, Table and view definitions: CREATE EXTERNAL TABLE tweets_raw ( id BIGINT, created_at STRING, text STRING, screen_name STRING, name STRING ) ROW FORMAT SERDE 'com.amazon.elasticmapreduce.JsonSerde' WITH SERDEPROPERTIES ( 'paths'='id, created_at, text, user.screen_nam