This message was deleted.
# generals
Slackbot
11/15/2023, 10:27 AMThis message was deleted.
t
Tijo Thomas
11/15/2023, 5:07 PMHave u tried converting the emoji in UTF-8 and tried ?
j
Jithin K J
11/16/2023, 3:10 AMYes, when I encoded in UTF-8, getting an error
Copy code
"java.lang.RuntimeException: org.apache.druid.sql.SqlPlanningException: Percent remainder '%' is not allowed under the current SQL conformance level" Copy code
SELECT added, comment FROM sample_data_test WHERE (__time BETWEEN TIMESTAMP '2009-10-24 00:00:00' AND TIMESTAMP '2023-10-25 00:00:00') AND comment IN ('🥰SHAE_BAE_BIIHHH🥰', 'test comment') GROUP BY added, comment, channel ORDER BY lower(channel) DESC LIMIT 15 OFFSET 0 Copy code
SELECT+added%2C+comment+FROM+sample_data_test+WHERE+%28__time+BETWEEN+TIMESTAMP+%272009-10-24+00%3A00%3A00%27+AND+TIMESTAMP+%272023-10-25+00%3A00%3A00%27%29+AND+comment+IN+%28%27%F0%9F%A5%B0SHAE_BAE_BIIHHH%F0%9F%A5%B0%27%2C+%27test+comment%27%29+GROUP+BY+added%2C+comment%2C+channel+ORDER+BY+lower%28channel%29+DESC+LIMIT+15+OFFSET+0t
Tijo Thomas
10/17/2024, 5:56 AMoh .. i dont think the encoding is supported
Tijo Thomas
10/17/2024, 5:57 AMi mean UTF-8 encoding is okay .. this seems to be like a URL encoding
Tijo Thomas
10/17/2024, 6:00 AMUTF 8 encoding for the same is like this -
Copy code
\x5c\x78\x35\x33\x5c\x78\x34\x35\x5c\x78\x34\x63\x5c\x78\x34\x35\x5c\x78\x34\x33\x5c\x78\x35\x34\x5c\x78\x32\x30\x5c\x78\x36\x31\x5c\x78\x36\x34\x5c\x78\x36\x34\x5c\x78\x36\x35\x5c\x78\x36\x34\x5c\x78\x32\x63\x5c\x78\x32\x30\x5c\x78\x36\x33\x5c\x78\x36\x66\x5c\x78\x36\x64\x5c\x78\x36\x64\x5c\x78\x36\x35\x5c\x78\x36\x65\x5c\x78\x37\x34\x5c\x78\x32\x30\x5c\x78\x34\x36\x5c\x78\x35\x32\x5c\x78\x34\x66\x5c\x78\x34\x64\x5c\x78\x32\x30\x5c\x78\x37\x33\x5c\x78\x36\x31\x5c\x78\x36\x64\x5c\x78\x37\x30\x5c\x78\x36\x63\x5c\x78\x36\x35\x5c\x78\x35\x66\x5c\x78\x36\x34\x5c\x78\x36\x31\x5c\x78\x37\x34\x5c\x78\x36\x31\x5c\x78\x35\x66\x5c\x78\x37\x34\x5c\x78\x36\x35\x5c\x78\x37\x33\x5c\x78\x37\x34\x5c\x78\x32\x30\x5c\x78\x35\x37\x5c\x78\x34\x38\x5c\x78\x34\x35\x5c\x78\x35\x32\x5c\x78\x34\x35\x5c\x78\x32\x30\x5c\x78\x32\x38\x5c\x78\x35\x66\x5c\x78\x35\x66\x5c\x78\x37\x34\x5c\x78\x36\x39\x5c\x78\x36\x64\x5c\x78\x36\x35\x5c\x78\x32\x30\x5c\x78\x34\x32\x5c\x78\x34\x35\x5c\x78\x35\x34\x5c\x78\x35\x37\x5c\x78\x34\x35\x5c\x78\x34\x35\x5c\x78\x34\x65\x5c\x78\x32\x30\x5c\x78\x35\x34\x5c\x78\x34\x39\x5c\x78\x34\x64\x5c\x78\x34\x35\x5c\x78\x35\x33\x5c\x78\x35\x34\x5c\x78\x34\x31\x5c\x78\x34\x64\x5c\x78\x35\x30\x5c\x78\x32\x30\x5c\x78\x32\x37\x5c\x78\x33\x32\x5c\x78\x33\x30\x5c\x78\x33\x30\x5c\x78\x33\x39\x5c\x78\x32\x64\x5c\x78\x33\x31\x5c\x78\x33\x30\x5c\x78\x32\x64\x5c\x78\x33\x32\x5c\x78\x33\x34\x5c\x78\x32\x30\x5c\x78\x33\x30\x5c\x78\x33\x30\x5c\x78\x33\x61\x5c\x78\x33\x30\x5c\x78\x33\x30\x5c\x78\x33\x61\x5c\x78\x33\x30\x5c\x78\x33\x30\x5c\x78\x32\x37\x5c\x78\x32\x30\x5c\x78\x34\x31\x5c\x78\x34\x65\x5c\x78\x34\x34\x5c\x78\x32\x30\x5c\x78\x35\x34\x5c\x78\x34\x39\x5c\x78\x34\x64\x5c\x78\x34\x35\x5c\x78\x35\x33\x5c\x78\x35\x34\x5c\x78\x34\x31\x5c\x78\x34\x64\x5c\x78\x35\x30\x5c\x78\x32\x30\x5c\x78\x32\x37\x5c\x78\x33\x32\x5c\x78\x33\x30\x5c\x78\x33\x32\x5c\x78\x33\x33\x5c\x78\x32\x64\x5c\x78\x33\x31\x5c\x78\x33\x30\x5c\x78\x32\x64\x5c\x78\x33\x32\x5c\x78\x33\x35\x5c\x78\x32\x30\x5c\x78\x33\x30\x5c\x78\x33\x30\x5c\x78\x33\x61\x5c\x78\x33\x30\x5c\x78\x33\x30\x5c\x78\x33\x61\x5c\x78\x33\x30\x5c\x78\x33\x30\x5c\x78\x32\x37\x5c\x78\x32\x39\x5c\x78\x32\x30\x5c\x78\x34\x31\x5c\x78\x34\x65\x5c\x78\x34\x34\x5c\x78\x32\x30\x5c\x78\x36\x33\x5c\x78\x36\x66\x5c\x78\x36\x64\x5c\x78\x36\x64\x5c\x78\x36\x35\x5c\x78\x36\x65\x5c\x78\x37\x34\x5c\x78\x32\x30\x5c\x78\x34\x39\x5c\x78\x34\x65\x5c\x78\x32\x30\x5c\x78\x32\x38\x5c\x78\x32\x37\x5c\x78\x66\x30\x5c\x78\x39\x66\x5c\x78\x61\x35\x5c\x78\x62\x30\x5c\x78\x35\x33\x5c\x78\x34\x38\x5c\x78\x34\x31\x5c\x78\x34\x35\x5c\x78\x35\x66\x5c\x78\x34\x32\x5c\x78\x34\x31\x5c\x78\x34\x35\x5c\x78\x35\x66\x5c\x78\x34\x32\x5c\x78\x34\x39\x5c\x78\x34\x39\x5c\x78\x34\x38\x5c\x78\x34\x38\x5c\x78\x34\x38\x5c\x78\x66\x30\x5c\x78\x39\x66\x5c\x78\x61\x35\x5c\x78\x62\x30\x5c\x78\x32\x37\x5c\x78\x32\x63\x5c\x78\x32\x30\x5c\x78\x32\x37\x5c\x78\x37\x34\x5c\x78\x36\x35\x5c\x78\x37\x33\x5c\x78\x37\x34\x5c\x78\x32\x30\x5c\x78\x36\x33\x5c\x78\x36\x66\x5c\x78\x36\x64\x5c\x78\x36\x64\x5c\x78\x36\x35\x5c\x78\x36\x65\x5c\x78\x37\x34\x5c\x78\x32\x37\x5c\x78\x32\x39\x5c\x78\x32\x30\x5c\x78\x34\x37\x5c\x78\x35\x32\x5c\x78\x34\x66\x5c\x78\x35\x35\x5c\x78\x35\x30\x5c\x78\x32\x30\x5c\x78\x34\x32\x5c\x78\x35\x39\x5c\x78\x32\x30\x5c\x78\x36\x31\x5c\x78\x36\x34\x5c\x78\x36\x34\x5c\x78\x36\x35\x5c\x78\x36\x34\x5c\x78\x32\x63\x5c\x78\x32\x30\x5c\x78\x36\x33\x5c\x78\x36\x66\x5c\x78\x36\x64\x5c\x78\x36\x64\x5c\x78\x36\x35\x5c\x78\x36\x65\x5c\x78\x37\x34\x5c\x78\x32\x63\x5c\x78\x32\x30\x5c\x78\x36\x33\x5c\x78\x36\x38\x5c\x78\x36\x31\x5c\x78\x36\x65\x5c\x78\x36\x65\x5c\x78\x36\x35\x5c\x78\x36\x63\x5c\x78\x32\x30\x5c\x78\x34\x66\x5c\x78\x35\x32\x5c\x78\x34\x34\x5c\x78\x34\x35\x5c\x78\x35\x32\x5c\x78\x32\x30\x5c\x78\x34\x32\x5c\x78\x35\x39\x5c\x78\x32\x30\x5c\x78\x36\x63\x5c\x78\x36\x66\x5c\x78\x37\x37\x5c\x78\x36\x35\x5c\x78\x37\x32\x5c\x78\x32\x38\x5c\x78\x36\x33\x5c\x78\x36\x38\x5c\x78\x36\x31\x5c\x78\x36\x65\x5c\x78\x36\x65\x5c\x78\x36\x35\x5c\x78\x36\x63\x5c\x78\x32\x39\x5c\x78\x32\x30\x5c\x78\x34\x34\x5c\x78\x34\x35\x5c\x78\x35\x33\x5c\x78\x34\x33\x5c\x78\x32\x30\x5c\x78\x34\x63\x5c\x78\x34\x39\x5c\x78\x34\x64\x5c\x78\x34\x39\x5c\x78\x35\x34\x5c\x78\x32\x30\x5c\x78\x33\x31\x5c\x78\x33\x35\x5c\x78\x32\x30\x5c\x78\x34\x66\x5c\x78\x34\x36\x5c\x78\x34\x36\x5c\x78\x35\x33\x5c\x78\x34\x35\x5c\x78\x35\x34\x5c\x78\x32\x30\x5c\x78\x33\x30Tijo Thomas
10/17/2024, 6:00 AMBut UTF 8 encoding is used while serializing the data before storage .
Tijo Thomas
10/17/2024, 6:01 AMCan u tell the context why u wanted to encode the query
Tijo Thomas
10/17/2024, 6:03 AMi feel u dont even need to url encode since queries are post request