I’m trying to select from a table, where the column names have underscores: i.e.
select underscore_column from table
and i believe q doesn’t like this since _ is reserved. How can I escape the _ in the statement?
thanks,
I’m trying to select from a table, where the column names have underscores: i.e.
select underscore_column from table
and i believe q doesn’t like this since _ is reserved. How can I escape the _ in the statement?
thanks,
_ should be ok in a column name.. are you sure there isn’t anything else? Can you send a meta of the table?
EDIT: unless you meant the column name started with an _ - that’s not allowed
If there is something dodgy about the column names you can always use functional select
http://code.kx.com/wiki/JB:QforMortals2/queries_q_sql#Functional_Forms
Thanks you were right. I think the underlying table was splayed or partitioned. I assigned my result to a new local table, and was able to do the select.