Hi, Amihay, Instead of "select *" you will have to explicitly specify the fields you want to select.
Let me look into implementing some support for "select *" in ibis.cpp in the next few days. John On 7/24/13 7:43 AM, amihay gonen wrote: > 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
