Guest User

Untitled

a guest
Jan 16th, 2019
62
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.46 KB | None | 0 0
  1. INSERT INTO outputTable
  2. SELECT
  3. ROW(col1, col1)
  4. FROM inputTable
  5. >>>> OK:
  6. {"outCol1":"dasdasdas","outCol2":"dasdasdas"}
  7.  
  8. INSERT INTO outputTable
  9. SELECT
  10. ROW('ttt', ROW('ppp'))
  11. FROM inputTable
  12. >>>> OK:
  13. {"outCol1":"ttt","outCol2":{"outCol3":"ppp"}}
  14.  
  15. INSERT INTO outputTable
  16. SELECT
  17. ROW('ttt', ROW(col1))
  18. FROM inputTable
  19. >>>> OK:
  20. {"outCol1":"ttt","outCol2":{"outCol3":"dasdasdas"}}
  21.  
  22. INSERT INTO outputTable
  23. SELECT
  24. ROW(col1, ROW(col1))
  25. FROM inputTable
  26. >>>> KO
  27.  
  28. Caused by: org.apache.calcite.sql.parser.impl.ParseException: Encountered ", ROW" at line 3, column 11.
  29. Was expecting one of:
  30. ")" ...
  31. "," <IDENTIFIER> ...
  32. "," <QUOTED_IDENTIFIER> ...
  33. "," <BACK_QUOTED_IDENTIFIER> ...
  34. "," <BRACKET_QUOTED_IDENTIFIER> ...
  35. "," <UNICODE_QUOTED_IDENTIFIER> ...
  36.  
  37. at org.apache.calcite.sql.parser.impl.SqlParserImpl.generateParseException(SqlParserImpl.java:23019)
  38. at org.apache.calcite.sql.parser.impl.SqlParserImpl.jj_consume_token(SqlParserImpl.java:22836)
  39. at org.apache.calcite.sql.parser.impl.SqlParserImpl.ParenthesizedSimpleIdentifierList(SqlParserImpl.java:4466)
  40. at org.apache.calcite.sql.parser.impl.SqlParserImpl.Expression3(SqlParserImpl.java:3328)
  41. at org.apache.calcite.sql.parser.impl.SqlParserImpl.Expression2b(SqlParserImpl.java:3066)
  42. at org.apache.calcite.sql.parser.impl.SqlParserImpl.Expression2(SqlParserImpl.java:3092)
  43. at org.apache.calcite.sql.parser.impl.SqlParserImpl.Expression(SqlParserImpl.java:3045)
  44. at ...
Add Comment
Please, Sign In to add comment