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.

Tab Delimited File as Upload Table not able to recognise columns in Hive.

Solved Go to solution

Tab Delimited File as Upload Table not able to recognise columns in Hive.

Explorer

Hi,

I am trying to load a tab delimited text file in Hive using Upload Table interface in HDP 2.6 Sandbox. I am able to upload files using the Upload Table interface when the files are comma or pipe separated. However, when it's a tab delimited, all data is displayed in a single column in preview and also the table definition below, is a single columnar, by default.

I don't know what the issue is. The file was downloaded from web, but when I create another similar file manually, that also gets into problem (the table definition has only one column).

Could anyone please help?

Thank you.

Regards,

Manoj.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: Tab Delimited File as Upload Table not able to recognise columns in Hive.

Guru

Hi @Manoj Dixit

I just downloaded a sample TSV file with public data as well, and am able to reproduce your issue when using Hive View 2.0 I tried the same thing with the original hive view (not 2.0), and it does appear to work correctly. - see the screenshot included. Using the older hive view should get you around the issue for now. I'll be submitting this in case it is a bug, and will update if if is not.

16599-screen-shot-2017-06-28-at-95833-am.png

View solution in original post

3 REPLIES 3
Highlighted

Re: Tab Delimited File as Upload Table not able to recognise columns in Hive.

Guru

Hi @Manoj Dixit

I just downloaded a sample TSV file with public data as well, and am able to reproduce your issue when using Hive View 2.0 I tried the same thing with the original hive view (not 2.0), and it does appear to work correctly. - see the screenshot included. Using the older hive view should get you around the issue for now. I'll be submitting this in case it is a bug, and will update if if is not.

16599-screen-shot-2017-06-28-at-95833-am.png

View solution in original post

Highlighted

Re: Tab Delimited File as Upload Table not able to recognise columns in Hive.

Explorer

Thanks @Sonu Sahi. Please let me know what's the outcome.

Highlighted

Re: Tab Delimited File as Upload Table not able to recognise columns in Hive.

Guru

hi @Manoj Dixit

We have a case open on the issue intenrally now :)

Don't have an account?
Coming from Hortonworks? Activate your account here