clarkyu2016/sql-beautify

Case When格式化问题

Opened this issue · 1 comments

原sql语句
SELECT
a.a1,
a.a2,
case WHEN exists(SELECT b1 FROM b WHERE b1 =100) then 0 ELSE 1 END AS b2
FROM a

在格式化后
SELECT a.a1,
--------- a.a2,
---------CASE WHEN exists(
SELECT b1
FROM b
WHERE b1 = 100) THEN 0 ELSE 1 END AS b2
FROM a

可否优化exists后括号内子查询的缩进,如
SELECT a.a1,
---------a.a2,
---------CASE WHEN exists
---------(
------------SELECT b1
------------FROM b
------------WHERE b1 = 100
---------) THEN 0 ELSE 1 END AS b2
FROM a

你好,因为该插件是基于hive语法设计,hive中目前不支持exist或者not exist这种子查询用法 。