assume the csv file is "/home/jinzhi/Desktop/test.csv"
login("admin","123456") db= database("dfs://tstdb", VALUE, 2000.01.01..2001.01.01) nameCol = `date`askO`askH`askL`askC`bidO`bidH`bidL`bidC`source`symbol; typeCol = `DATE`DOUBLE`DOUBLE`DOUBLE`DOUBLE`DOUBLE`DOUBLE`DOUBLE`DOUBLE`SYMBOL`SYMBOL schemaTb = table(1:0, nameCol, typeCol); nx= db.createPartitionedTable(schemaTb, 'nx', `date) def dataTransform(mutable t) { return t.replaceColumn!(`date, date(t.date)) } pt=loadTextEx(dbHandle=db,tableName=`nx , partitionColumns=`date,filename="/home/jinzhi/Desktop/test.csv",transform=dataTransform);