key_value
Pairs of keys and values joined by ampersands, such as name=John&city=NewYork: the query string at the end of a web address, or the body of an HTTP POST.
1 key_value type: Query String Parameters.
The key_value type
Query String Parameters
query_stringVARCHAR
name=John&age=30&city=NewYor…Which key_value type is it?
1 of 1 key_value type accepts it.
| Type | Reads it as |
|---|---|
Query String Parameters query_string | name=John&age=30&city=NewYork |
Use it
Shell
printf '%s\n' 'name=John&age=30&city=NewYork' 'q=python&page=1' > column.txt
finetype infer -f column.txt --mode columnDuckDB
SELECT ft_profile(v) FROM (VALUES ('name=John&age=30&city=NewYork'), ('q=python&page=1')) t(v);After q=python&page=1, one type remains: query_string.