login("admin", "123456")
//鍦―olphinDB涓牴鎹甊edShift鐨勬暟鎹垱寤哄垎甯冨紡琛�
db=database("dfs://redshift",HASH,[INT,10]);
dt=table(300000000:0,["channelno","applseqnum","mdstreamid","bidapplseqnum","offerapplseqnum","securityid","securityidsource","lastpx","lastqty","exectype","transacttime","localtime","seqno","transactiondate"],[INT,INT,SYMBOL,INT,INT,SYMBOL,SYMBOL,DOUBLE,DOUBLE,INT,TIME,TIME,INT,DATE]);
pt=createPartitionedTable(db,dt,"dfstable","channelno");

//鍔犺浇鎻掍欢
loadPlugin("./plugins/odbc/PluginODBC.txt")

//杩炴帴RS鏁版嵁搴�
conn = odbc::connect("Driver={Amazon Redshift (x64)}; Server=ddb-redshift-test.cpsycpmgsvcy.us-west-2.redshift.amazonaws.com; Database=ddb-test;User=ddbadmin;Password=DolphinDB123;")

//鏌ヨ鏁版嵁骞舵彃鍏olphinDB
odbc::query(conn, "select * from trades_sz",pt)

//楠岃瘉鏌ヨ鐨勭粨鏋�
select top 10 * from pt