Hello John, I have a taken few partitions, made a table of them and run a query. The result is following table:
Table (in memory) _IyE70 (GROUP BY count(*),e0id11,e0id12,e0id4,e0id7,e0id8,max(e0id153),min(e0id152),sum(e0id1),sum(e0id2) on table P3my3 (GROUP BY COUNT(*), e0id11, e0id12, e0id4, e0id7, e0id8, MAX(e0id153), MIN(e0id152), SUM(e0id1), SUM(e0id2) on table kCejL2)) contsists of 10 columns and 964529 rows _.0 UINT COUNT(*) e0id11 USHORT e0id11 e0id12 UINT e0id12 e0id4 UBYTE e0id4 e0id7 USHORT e0id7 e0id8 UINT e0id8 _.6 ULONG MAX(e0id153) _.7 ULONG MIN(e0id152) _.8 DOUBLE SUM(e0id1) _.9 DOUBLE SUM(e0id2) Now I need to use data from this table, and also do summary of the columns that have COUNT, MAX, MIN functions. The problem is that I do not know, how to specify such a query. I tried following for starters - just select the columns that I want using select() function on the table: countQuery::setWhereClause accepted new query conditions "1 == 1" Constructed in-memory data partition n19k6 -- filter::sift2(SELECT _.0,_.6,_.7,_.8,_.9 FROM 1 data partition WHERE 1 == 1) -- with 5 columns filter::sift2(SELECT _.0,_.6,_.7,_.8,_.9 FROM 1 data partition WHERE 1 == 1) -- processing data partition _IyE70 countQuery assigned data partition _IyE70 countQuery::evaluate -- Select count(*) From _IyE70 Where 1 == 1 --> 964529 countQuery::evaluate -- duration: 0 sec(CPU), 2.31266e-05 sec(elapsed) Warning -- bord[n19k6]::append failed to locate 0 in the list of names in _.0,_.6,_.7,_.8,_.9 Warning -- filter::sift2(SELECT _.0,_.6,_.7,_.8,_.9 FROM 1 data partition WHERE 1 == 1) failed to append 964529 rows from _IyE70, ierr = -13 Warning -- filter::sift2(SELECT _.0,_.6,_.7,_.8,_.9 FROM 1 data partition WHERE 1 == 1) failed to produce any result, the last error code was -13 filter::sift2(SELECT _.0,_.6,_.7,_.8,_.9 FROM 1 data partition WHERE 1 == 1) -- duration: 0 sec(CPU), 0.000105619 sec(elapsed) Table n19k6 (filter::sift2(SELECT _.0,_.6,_.7,_.8,_.9 FROM 1 data partition WHERE 1 == 1)) contains 0 row but no columns As you can see, I used the column names that are accessible through columnNames() function. What is the right way to query such a table? Thank you, Petr _______________________________________________ FastBit-users mailing list [email protected] https://hpcrdm.lbl.gov/cgi-bin/mailman/listinfo/fastbit-users
