Im trying to create a exteral hive database with JsonSerde as follows : CREATE EXTERNAL TABLE test1
(
user string
)
ROW FORMAT SERDE 'org.apache.hive.hcatalog.data.JsonSerDe'
LOCATION '/user/ec2-user/test_data/'; Problem is I have a input file with empty blank lines between data. {"user":"chill1"}
{"user":"chill2"}
{"user":"chill3"}
{"user":"chill4"}
{"user":"chill5"} If I do count on hive table, I get 9 lines. If I remove lines from source text file then I get the total count as 5. Anybody can help on this one please.
... View more
