Back to Clickhouse

Form

docs/en/interfaces/formats/Form.md

26.4.1.1-new768 B
Original Source
InputOutputAlias

Description {#description}

The Form format can be used to read a single record in the application/x-www-form-urlencoded format in which data is formatted as key1=value1&key2=value2.

Example usage {#example-usage}

Given a file data.tmp placed in the user_files path with some URL encoded data:

text
t_page=116&c.e=ls7xfkpm&c.tti.m=raf&rt.start=navigation&rt.bmr=390%2C11%2C10
sql
SELECT * FROM file(data.tmp, Form) FORMAT vertical;
response
Row 1:
──────
t_page:   116
c.e:      ls7xfkpm
c.tti.m:  raf
rt.start: navigation
rt.bmr:   390,11,10

Format settings {#format-settings}