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.

how to restrict the rows from the file while creating external table?

how to restrict the rows from the file while creating external table?

New Contributor

Hi ,

Can anyone tell me that if there is any option to restrict the rows from the file (.csv) while creating the external table.

Thanks,

Saravanan

2 REPLIES 2

Re: how to restrict the rows from the file while creating external table?

Super Collaborator

@Saravanan Appanasamy Can you explain what you mean by "restrict the rows"?

Re: how to restrict the rows from the file while creating external table?

New Contributor

Hi James,

The requirement is like, to load only the header row (first row) of each files in the directory, which is mapped to the external table.

Would that be possible?

Thanks,

Saravanan

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