I'm trying to do a bulk load from a CSV file to a table on Impala. Table have the same fields as my CSV file and I'm using the following command to load it:
LOAD DATA INPATH '/user/myuser/data/file.csv' INTO TABLE my_database.my_table;
The path is HDFS path and my file uses \t as separator.
When I execute the instruction, everything seems to be okay. After that I query for count(*) and I've exact the same number of rows that lines I had in my file, but when I do a SELECT, all rows and fields are NULL.
I readed in Cloudera documentation that:
"If a text file has fewer fields than the columns in the corresponding Impala table, all the corresponding columns are set to NULL when the data in that file is read by an Impala query."
But since I have the same number of columns I don't know which is the problem in here. Anybody has idea or possibles solutions?
Thanks you so muh in advance.
I thought I had tried this before but seems like I didnt it in the right way. Now I tried once again and it worked. Thanks you so much and sorry for the stupid question.