I am using phoenix 4.6 and trying to bulk load data into a table from a csv file using the psql.py utility. How do I map the table columns to the header values in the csv file through the "-h" argument?
For e.g. Assume my phoenix table does not match the columns in the csv. The phoenix table looks like this
CREATE TABLE PRODUCT(
PRODUCT_ID BIGINT NOT NULL
,CONSTRAINT pk PRIMARY KEY (PRODUCT_ID)
while the csv has lot of other columns for e.g.
Note the order of the columns is also different. Execute the utility with the below arguments fails with an error "Don't know how to interpret argument 'brand_name,'
python psql.py -t PRODUCT -h product_class_id, product_id, brand_name, product_name localhost product.csv
How can I fix this?