Hi John, I've run into following issue: We have multiple tables, each with different set of columns. We want to run the same query on all of them. The problem is when the query contains a column that is not present in a table. Even if the query is something like col1 != 0, the column col1 is required and no results are returned.
An example: table1: col1, col2, col3 table2: col2, col3, col4 query: col2 = 42 and col4 != 0 I would want the query to give me all rows from table1 with col2 = 42, thus ignoring the missing col4. Is that possible to achieve in FastBit query? Since we have quite lot of different table schemes, it is not easy to adjust the given query for each of the tables. Thank you for your help, Petr
_______________________________________________ FastBit-users mailing list [email protected] https://hpcrdm.lbl.gov/cgi-bin/mailman/listinfo/fastbit-users
