clickhouse-java icon indicating copy to clipboard operation
clickhouse-java copied to clipboard

When creating a parameterized view using clickhouse-jdbc, a query parsing error occurs

Open com-exem-route7 opened this issue 1 year ago • 0 comments

Description

Occasionally, when creating a parameterized view, the query does not get parsed correctly.

  • ClickHouse Version: 24.5.1.1763 (2R-1S)
  • ClickHouse JDBC Version: clickhouse-jdbc-0.6.2-all.jar

Create Parameterized View Statement

CREATE VIEW default.test
AS 
WITH    
    toDateTime({from:String}, 'Asia/Seoul') AS FROM,    
    date_add(FROM, INTERVAL 1 MINUTE) AS TO,    
    {target_id:String} AS TARGET_ID 
SELECT FROM, TO, TARGET_ID

Debug

image

Result

CREATE VIEW default.test
AS 
WITH    
    toDateTime({from:String}, 'Asia/Seoul') AS FROM,    
    date_add(FROM, INTERVAL 1 MINUTE) AS TO,    
    {target_id:String} AS TARGET_ID 
SELECT FROM, TO, TARGET_ID
;


SELECT * 
FROM system.query_log 
WHERE 
    event_date = '2024-09-10' 
    AND event_time >= toDateTime('2024-09-10 16:14:00', 'Asia/Seoul') 
    AND user = 'admin'
;

image

com-exem-route7 avatar Sep 10 '24 07:09 com-exem-route7