I have a query that looks like the following:
index=<> host=<> |rex=<> spath <>|table a,k,h|sort time|append[|dbquery DB "select X,Z,W,P from tableT where <> Order By timecol"]
the result set has the following columns:
While I expect
How can I get rid of this automatic alphabetical sorting?
While I run the dbquery alone, it works fine and shows me the expected columns.
I have gotten around this before by using the table command, so in your example :
index= host= |rex= spath |table a,k,h|sort time|append[|dbquery DB "select X,Z,W,P from table_T where Order By time_col"] | table a,k,h,X,Z,W,P
View solution in original post
Thanks a lot @russellliss. This was really helpful