01-24-2018 07:06 PM - last edited on 01-25-2018 08:07 AM by cjervis
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:
I defined the table as below.
CREATE EXTERNAL TABLE TLogEntry2
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