metrico/urleng

Distributed URL Engine for ClickHouse (public service)

urleng's Issues

Unknown setting custom_url on 22.11.1

Hello there.

Great idea of utilizing url table function : )

There is one small issue tho, on the main page, it says we can do this:

SET custom_url = 'https://urleng.com/4c5u94cw592bsq9wypba'

which is actually not possible.

SET custom_url = 'https://urleng.com/4c5u94cw592bsq9wypba'

Query id: 88fbda2b-f2ad-4b99-ba1c-39e2b5f141e3


0 rows in set. Elapsed: 0.001 sec. 

Received exception from server (version 22.11.1):
Code: 115. DB::Exception: Received from localhost:9000. DB::Exception: Unknown setting custom_url. (UNKNOWN_SETTING)

But this works:

:) SET param_url = 'https://urleng.com/abc'

SET param_url = https://urleng.com/abc

Query id: 1a4c6ab9-e3bf-436f-9723-335a9d55f7c8

Ok.

0 rows in set. Elapsed: 0.001 sec. 

:) INSERT INTO FUNCTION url({url:String}, JSONEachRow, 'key String, value UInt64') VALUES ('hello', 1)

INSERT INTO FUNCTION url({url:String}, JSONEachRow, 'key String, value UInt64') FORMAT Values

Query id: c6e52e51-963b-4233-aa65-e0792e29b3e1

Ok.

1 row in set. Elapsed: 0.802 sec. 

:) SELECT * FROM url({url:String}, JSONEachRow, 'key String, value UInt64')

SELECT *
FROM url({url:String}, JSONEachRow, 'key String, value UInt64')

Query id: aa0d6fbf-8738-47f5-a365-b89213a023bc

┌─key───┬─value─┐
│ hello │     1 │
└───────┴───────┘

1 row in set. Elapsed: 0.551 sec. 

:)