Can I know how to use --raw?

[crotoc]

I indexed a file using zindex by column 4. I want to search for the columns containing a keyword. Can you guys tell me how to use --raw to achieve this. I don't know the default table name and the index name underlying zindex. Please give me some info about this. Thanks!

[crotoc]

Let me answer it by myself.

If you want to use --raw, you need to index your file through a json (--config). My json is like this:

{
"indexes": [
{
"type": "field",
"delimiter": "\t",
"fieldNum": 4,
"name":"first"
}
]
}

The most important value in the json is the "name".

Then I can search by --raw by this way:
zq --raw ''select a.line from index_first a where (a.key like "ID" OR a.key like "%something%""

Hope this help others.