Cloudera Community

Support Questions

Find answers, ask questions, and share your expertise
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Advanced Search
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

csv to postgresql

Labels:
avatar
author-rank ZAP
New Contributor

Created ‎11-18-2020 03:13 AM

How to create table from csv file 

1,162 Views
0 Kudos
3 REPLIES 3

avatar
author-rank ZAP
New Contributor

Created ‎11-18-2020 03:15 AM

column names from first line csv

1,161 Views
0 Kudos

avatar
author-rank Faerballert
Expert Contributor

Created ‎11-19-2020 10:11 AM

Your csv is content of the flowfile?

Use PutDatabaseRecord and create CsvReader as Controller.

You dont need an Avro Schema if the column names of both are the same

1,122 Views
0 Kudos

avatar
author-rank ZAP
New Contributor

Created ‎11-20-2020 12:03 AM

my csv is file.csv

ok scheme dont need. is possible auto-create table with column names from first line csv?

1,106 Views
0 Kudos
Announcements
Product Announcements
[ANNOUNCE] Cloudera on Public Cloud Runtime 7.2.18 is GA!
What's New @ Cloudera
Cloudera Operational Database (COD) supports enhancements to...
Community Announcements
March 2024 Community Highlights
Community Announcements
Celebrating 100,000 Members: A Journey of Growth and Connect...
Product Announcements
[ANNOUNCE] New Cloudera JDBC Connector for Apache Hive 2.6.2...
View More Announcements