load the dictionary file when loading data

classic Classic list List threaded Threaded
1 message Options
ytx
Reply | Threaded
Open this post in threaded view
|

load the dictionary file when loading data

ytx
I just want to know how to load the dictionary file when loading data.
example:load data inpath '/person.txt' into table person OPTIONS('DELIMITER'='|','QUOTECHAR'='"','FILEHEADER'='id,name,birthday,start_time,work_locations,course','COMPLEX_DELIMITER_LEVEL_1'='$','ALL_DICTIONARY_PATH'='/opt/dictionary/allcolumn.dictionary');
When I add content in the allcolumn.dictionary file, the load fails, but the content is empty and loaded successfully. So I wonder if it's my allcolumn.dictionary is wrong? AND if it is added ALL_DICTIONARY_PATH what effect?