hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Igor Kravzov <>
Subject JsonSerDe file format question
Date Wed, 08 Jun 2016 18:55:25 GMT
I am merging multiple JSON file in a bigger one before saving it to HDFS.
So merged file looks like this


JSON data concatenated one after another, not on a new line.

I also created table like this
CREATE external TABLE testtable
  id bigint,
  url string,
partitioned by (yyyymmdd int)
location '/mytest/test';

and added partition
alter table testtable
  add if not exists partition (yyyymmdd=20160608) location

There are 3 file with r JSON records each. But when I run select * from
testtable; it return me only first row from each one of file nested of 9.

What can be the problem?

View raw message