Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- INSERT INTO outputTable
- SELECT
- ROW(col1, col1)
- FROM inputTable
- >>>> OK:
- {"outCol1":"dasdasdas","outCol2":"dasdasdas"}
- INSERT INTO outputTable
- SELECT
- ROW('ttt', ROW('ppp'))
- FROM inputTable
- >>>> OK:
- {"outCol1":"ttt","outCol2":{"outCol3":"ppp"}}
- INSERT INTO outputTable
- SELECT
- ROW('ttt', ROW(col1))
- FROM inputTable
- >>>> OK:
- {"outCol1":"ttt","outCol2":{"outCol3":"dasdasdas"}}
- INSERT INTO outputTable
- SELECT
- ROW(col1, ROW(col1))
- FROM inputTable
- >>>> KO
- Caused by: org.apache.calcite.sql.parser.impl.ParseException: Encountered ", ROW" at line 3, column 11.
- Was expecting one of:
- ")" ...
- "," <IDENTIFIER> ...
- "," <QUOTED_IDENTIFIER> ...
- "," <BACK_QUOTED_IDENTIFIER> ...
- "," <BRACKET_QUOTED_IDENTIFIER> ...
- "," <UNICODE_QUOTED_IDENTIFIER> ...
- at org.apache.calcite.sql.parser.impl.SqlParserImpl.generateParseException(SqlParserImpl.java:23019)
- at org.apache.calcite.sql.parser.impl.SqlParserImpl.jj_consume_token(SqlParserImpl.java:22836)
- at org.apache.calcite.sql.parser.impl.SqlParserImpl.ParenthesizedSimpleIdentifierList(SqlParserImpl.java:4466)
- at org.apache.calcite.sql.parser.impl.SqlParserImpl.Expression3(SqlParserImpl.java:3328)
- at org.apache.calcite.sql.parser.impl.SqlParserImpl.Expression2b(SqlParserImpl.java:3066)
- at org.apache.calcite.sql.parser.impl.SqlParserImpl.Expression2(SqlParserImpl.java:3092)
- at org.apache.calcite.sql.parser.impl.SqlParserImpl.Expression(SqlParserImpl.java:3045)
- at ...
Add Comment
Please, Sign In to add comment