Reply
Explorer
Posts: 6
Registered: ‎04-23-2017

Hive No Error - No Data from JSON FIle

[ Edited ]

Community

 

  I have a issue and have tried for 12 hours to figure it out and need some help. I have a JSON this very straight forward but for some reason Hive is not showing data. The file is named tlog.json and here is its structure:

 

{"TableName":"dbo.tlog","TxnID":"","OperationName":"INSERT","SEQUENCE":"00000020005B6C95001B","TimeStamp":"1969-12-31T19:00:00.000-05:00"}

 

I defined the table as below.

 

CREATE EXTERNAL TABLE TLogEntry2
(
TableName string,
TxnID string,
OperationName string,
SEQUENCE string,
TimeStamp string
)
ROW FORMAT SERDE 'org.apache.hive.hcatalog.data.JsonSerDe' LOCATION '/tmp/strim_kafka_StriimTLogData'

There are no errors when the table is created but no results are shown. 

 

Please help me with this issue. I have had no luck and have exhausted myself trying to find the issue. Things tried -

1. Validated the json file

2. Varied security

3. Read through numerous blogs

 

Thnks

Announcements