Support Questions
Find answers, ask questions, and share your expertise

Hive external table on Hadoop archive files

Hive external table on Hadoop archive files

Expert Contributor

Hi,

I created an external table on HAR files but i'm not able to see meaningful records. Is this supported in Hive and what SerDe should be used? I currently run HDP 2.6

1 REPLY 1

Re: Hive external table on Hadoop archive files

Hello @Joshua Adeleke!
I'm not used to HAR files + Hive, but did you set the following parameters?

hive> set hive.archive.enabled=true;
hive> set hive.archive.har.parentdir.settable=true;
hive> set har.partfile.size=1099511627776;
hive> msck repair table <EXTERNAL TABLE>;
Hope this helps!