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 match CSV file header names with already saved names for file in table

Highlighted

How to match CSV file header names with already saved names for file in table

New Contributor

I have saved column names for file in the hive table which is as below

109372-capture1.png

I have CSV file as below

A|B|C

1|2|3

4|5|6

and I want to match the columns of CSV file with the Column names saved in the table.

The result I want is:

if the file has the same column names as stored in the table to match then do some processing else exit and throw an email of mismatch schema.


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