Hi john , how can i control the order of the fields return from the following query : select * from , in a way it will be the same order of the fields of the ardea command
For example , I've created a lineitem table with arda , where partkey is the first field , but the fields order is commitdate ,... I want to that select * from ... ,will be translate to select orderkey,partkey etc. AFAIK , the areda loading utility defines the format of the table . BEGIN HEADER Name = lineitem1 Description = c:\db\ardea -d c:\db\fastbit\lineitem1 -b | -m orderkey:int,partkey:int,suppkey:int,linenumber:int,quantity:float,price:float,discount:float,tax:float,returnflag:text,linestatus:key,shipdate:int,commitdate:int,receipdate:int,shipinstuct:text,shipmode:key -t c:\db\row_data\lineitem1.tbl Number_of_rows = 59986052 Number_of_columns = 15 Timestamp = 1372768082 END HEADER Begin Column name = commitdate data_type = INT End Column Begin Column name = discount data_type = FLOAT End Column Begin Column name = linenumber data_type = INT End Column
_______________________________________________ FastBit-users mailing list [email protected] https://hpcrdm.lbl.gov/cgi-bin/mailman/listinfo/fastbit-users
