[jira] [Commented] (CALCITE-3511) Failed to serialize SqlNode to json string using jackson
[ https://issues.apache.org/jira/browse/CALCITE-3511?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16979942#comment-16979942 ] groobyming commented on CALCITE-3511: - Thanks for all your replies [~danny0405] [~julianhyde], I will try to create a tool that converts SqlNode to Json string > Failed to serialize SqlNode to json string using jackson > > > Key: CALCITE-3511 > URL: https://issues.apache.org/jira/browse/CALCITE-3511 > Project: Calcite > Issue Type: New Feature > Components: core >Affects Versions: 1.21.0 >Reporter: groobyming >Priority: Major > Labels: SqlNode, calcite, calcite-core, jackson, json > Attachments: screenshot-1.png > > > Failed to serialize SqlNode to json string using jackson, Exception as > follows: > Caused by: java.lang.UnsupportedOperationException: class > org.apache.calcite.sql.SqlSelectOperator: SELECT > at org.apache.calcite.util.Util.needToImplement(Util.java:967) > at > org.apache.calcite.sql.SqlOperator.getOperandCountRange(SqlOperator.java:201) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) > at > com.fasterxml.jackson.databind.ser.BeanPropertyWriter.serializeAsField(BeanPropertyWriter.java:664) > at > com.fasterxml.jackson.databind.ser.std.BeanSerializerBase.serializeFields(BeanSerializerBase.java:689) > ... 32 more -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Commented] (CALCITE-3511) Failed to serialize SqlNode to json string using jackson
[ https://issues.apache.org/jira/browse/CALCITE-3511?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16978907#comment-16978907 ] Julian Hyde commented on CALCITE-3511: -- Feel free to contribute a utility that converts SqlNode to JSON and/or JSON to SqlNode. With tests, of course. :) > Failed to serialize SqlNode to json string using jackson > > > Key: CALCITE-3511 > URL: https://issues.apache.org/jira/browse/CALCITE-3511 > Project: Calcite > Issue Type: New Feature > Components: core >Affects Versions: 1.21.0 >Reporter: groobyming >Priority: Major > Labels: SqlNode, calcite, calcite-core, jackson, json > Attachments: screenshot-1.png > > > Failed to serialize SqlNode to json string using jackson, Exception as > follows: > Caused by: java.lang.UnsupportedOperationException: class > org.apache.calcite.sql.SqlSelectOperator: SELECT > at org.apache.calcite.util.Util.needToImplement(Util.java:967) > at > org.apache.calcite.sql.SqlOperator.getOperandCountRange(SqlOperator.java:201) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) > at > com.fasterxml.jackson.databind.ser.BeanPropertyWriter.serializeAsField(BeanPropertyWriter.java:664) > at > com.fasterxml.jackson.databind.ser.std.BeanSerializerBase.serializeFields(BeanSerializerBase.java:689) > ... 32 more -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Commented] (CALCITE-3511) Failed to serialize SqlNode to json string using jackson
[ https://issues.apache.org/jira/browse/CALCITE-3511?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16978099#comment-16978099 ] Danny Chen commented on CALCITE-3511: - There is a SqlVisitor you can use to visit the AST, but for each node itself, you should unparse it by your self. > Failed to serialize SqlNode to json string using jackson > > > Key: CALCITE-3511 > URL: https://issues.apache.org/jira/browse/CALCITE-3511 > Project: Calcite > Issue Type: New Feature > Components: core >Affects Versions: 1.21.0 >Reporter: groobyming >Priority: Major > Labels: SqlNode, calcite, calcite-core, jackson, json > Attachments: screenshot-1.png > > > Failed to serialize SqlNode to json string using jackson, Exception as > follows: > Caused by: java.lang.UnsupportedOperationException: class > org.apache.calcite.sql.SqlSelectOperator: SELECT > at org.apache.calcite.util.Util.needToImplement(Util.java:967) > at > org.apache.calcite.sql.SqlOperator.getOperandCountRange(SqlOperator.java:201) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) > at > com.fasterxml.jackson.databind.ser.BeanPropertyWriter.serializeAsField(BeanPropertyWriter.java:664) > at > com.fasterxml.jackson.databind.ser.std.BeanSerializerBase.serializeFields(BeanSerializerBase.java:689) > ... 32 more -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Commented] (CALCITE-3511) Failed to serialize SqlNode to json string using jackson
[ https://issues.apache.org/jira/browse/CALCITE-3511?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16978051#comment-16978051 ] groobyming commented on CALCITE-3511: - Hi Danny, I think i can get the json string by visiting the ast , although that is not the best way Thanks > Failed to serialize SqlNode to json string using jackson > > > Key: CALCITE-3511 > URL: https://issues.apache.org/jira/browse/CALCITE-3511 > Project: Calcite > Issue Type: New Feature > Components: core >Affects Versions: 1.21.0 >Reporter: groobyming >Priority: Major > Labels: SqlNode, calcite, calcite-core, jackson, json > Attachments: screenshot-1.png > > > Failed to serialize SqlNode to json string using jackson, Exception as > follows: > Caused by: java.lang.UnsupportedOperationException: class > org.apache.calcite.sql.SqlSelectOperator: SELECT > at org.apache.calcite.util.Util.needToImplement(Util.java:967) > at > org.apache.calcite.sql.SqlOperator.getOperandCountRange(SqlOperator.java:201) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) > at > com.fasterxml.jackson.databind.ser.BeanPropertyWriter.serializeAsField(BeanPropertyWriter.java:664) > at > com.fasterxml.jackson.databind.ser.std.BeanSerializerBase.serializeFields(BeanSerializerBase.java:689) > ... 32 more -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Commented] (CALCITE-3511) Failed to serialize SqlNode to json string using jackson
[ https://issues.apache.org/jira/browse/CALCITE-3511?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16977925#comment-16977925 ] Julian Hyde commented on CALCITE-3511: -- There is currently no way to convert SqlNode to JSON. > Failed to serialize SqlNode to json string using jackson > > > Key: CALCITE-3511 > URL: https://issues.apache.org/jira/browse/CALCITE-3511 > Project: Calcite > Issue Type: Bug > Components: core >Affects Versions: 1.21.0 >Reporter: groobyming >Priority: Critical > Labels: SqlNode, calcite, calcite-core, jackson, json > Attachments: screenshot-1.png > > > Failed to serialize SqlNode to json string using jackson, Exception as > follows: > Caused by: java.lang.UnsupportedOperationException: class > org.apache.calcite.sql.SqlSelectOperator: SELECT > at org.apache.calcite.util.Util.needToImplement(Util.java:967) > at > org.apache.calcite.sql.SqlOperator.getOperandCountRange(SqlOperator.java:201) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) > at > com.fasterxml.jackson.databind.ser.BeanPropertyWriter.serializeAsField(BeanPropertyWriter.java:664) > at > com.fasterxml.jackson.databind.ser.std.BeanSerializerBase.serializeFields(BeanSerializerBase.java:689) > ... 32 more -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Commented] (CALCITE-3511) Failed to serialize SqlNode to json string using jackson
[ https://issues.apache.org/jira/browse/CALCITE-3511?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16977488#comment-16977488 ] groobyming commented on CALCITE-3511: - Hi Danny, Thanks for your reply And how can i get the abstract syntax tree as follows: !screenshot-1.png! > Failed to serialize SqlNode to json string using jackson > > > Key: CALCITE-3511 > URL: https://issues.apache.org/jira/browse/CALCITE-3511 > Project: Calcite > Issue Type: Bug > Components: core >Affects Versions: 1.21.0 >Reporter: groobyming >Priority: Critical > Labels: SqlNode, calcite, calcite-core, jackson, json > Attachments: screenshot-1.png > > > Failed to serialize SqlNode to json string using jackson, Exception as > follows: > Caused by: java.lang.UnsupportedOperationException: class > org.apache.calcite.sql.SqlSelectOperator: SELECT > at org.apache.calcite.util.Util.needToImplement(Util.java:967) > at > org.apache.calcite.sql.SqlOperator.getOperandCountRange(SqlOperator.java:201) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) > at > com.fasterxml.jackson.databind.ser.BeanPropertyWriter.serializeAsField(BeanPropertyWriter.java:664) > at > com.fasterxml.jackson.databind.ser.std.BeanSerializerBase.serializeFields(BeanSerializerBase.java:689) > ... 32 more -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Commented] (CALCITE-3511) Failed to serialize SqlNode to json string using jackson
[ https://issues.apache.org/jira/browse/CALCITE-3511?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16977455#comment-16977455 ] Danny Chen commented on CALCITE-3511: - [~groobyming], maybe RelJsonWriter is what you need, it converts a relational expression to JSON format. > Failed to serialize SqlNode to json string using jackson > > > Key: CALCITE-3511 > URL: https://issues.apache.org/jira/browse/CALCITE-3511 > Project: Calcite > Issue Type: Bug > Components: core >Affects Versions: 1.21.0 >Reporter: groobyming >Priority: Critical > Labels: SqlNode, calcite, calcite-core, jackson, json > > Failed to serialize SqlNode to json string using jackson, Exception as > follows: > Caused by: java.lang.UnsupportedOperationException: class > org.apache.calcite.sql.SqlSelectOperator: SELECT > at org.apache.calcite.util.Util.needToImplement(Util.java:967) > at > org.apache.calcite.sql.SqlOperator.getOperandCountRange(SqlOperator.java:201) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) > at > com.fasterxml.jackson.databind.ser.BeanPropertyWriter.serializeAsField(BeanPropertyWriter.java:664) > at > com.fasterxml.jackson.databind.ser.std.BeanSerializerBase.serializeFields(BeanSerializerBase.java:689) > ... 32 more -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Commented] (CALCITE-3511) Failed to serialize SqlNode to json string using jackson
[ https://issues.apache.org/jira/browse/CALCITE-3511?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16977390#comment-16977390 ] groobyming commented on CALCITE-3511: - Hi Julian, I want to get the Ast in json string format, Is there any other way to achive this goal. Thank you for the quick response > Failed to serialize SqlNode to json string using jackson > > > Key: CALCITE-3511 > URL: https://issues.apache.org/jira/browse/CALCITE-3511 > Project: Calcite > Issue Type: Bug > Components: core >Affects Versions: 1.21.0 >Reporter: groobyming >Priority: Critical > Labels: SqlNode, calcite, calcite-core, jackson, json > > Failed to serialize SqlNode to json string using jackson, Exception as > follows: > Caused by: java.lang.UnsupportedOperationException: class > org.apache.calcite.sql.SqlSelectOperator: SELECT > at org.apache.calcite.util.Util.needToImplement(Util.java:967) > at > org.apache.calcite.sql.SqlOperator.getOperandCountRange(SqlOperator.java:201) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) > at > com.fasterxml.jackson.databind.ser.BeanPropertyWriter.serializeAsField(BeanPropertyWriter.java:664) > at > com.fasterxml.jackson.databind.ser.std.BeanSerializerBase.serializeFields(BeanSerializerBase.java:689) > ... 32 more -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Commented] (CALCITE-3511) Failed to serialize SqlNode to json string using jackson
[ https://issues.apache.org/jira/browse/CALCITE-3511?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16976324#comment-16976324 ] Julian Hyde commented on CALCITE-3511: -- Why do you think that SqlNode should be serializable? > Failed to serialize SqlNode to json string using jackson > > > Key: CALCITE-3511 > URL: https://issues.apache.org/jira/browse/CALCITE-3511 > Project: Calcite > Issue Type: Bug > Components: core >Affects Versions: 1.21.0 >Reporter: groobyming >Priority: Critical > Labels: SqlNode, calcite, calcite-core, jackson, json > > Failed to serialize SqlNode to json string using jackson, Exception as > follows: > Caused by: java.lang.UnsupportedOperationException: class > org.apache.calcite.sql.SqlSelectOperator: SELECT > at org.apache.calcite.util.Util.needToImplement(Util.java:967) > at > org.apache.calcite.sql.SqlOperator.getOperandCountRange(SqlOperator.java:201) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) > at > com.fasterxml.jackson.databind.ser.BeanPropertyWriter.serializeAsField(BeanPropertyWriter.java:664) > at > com.fasterxml.jackson.databind.ser.std.BeanSerializerBase.serializeFields(BeanSerializerBase.java:689) > ... 32 more -- This message was sent by Atlassian Jira (v8.3.4#803005)