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);