Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

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!