Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

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

avatar
Contributor

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

avatar
Guru
hide-solution

This problem has been solved!

Want to get a detailed solution you have to login/registered on the community

Register/Login
3 REPLIES 3

avatar
Guru
hide-solution

This problem has been solved!

Want to get a detailed solution you have to login/registered on the community

Register/Login

avatar
Contributor

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

avatar
Guru

hi @Manoj Dixit

We have a case open on the issue intenrally now 🙂