[jira] [Commented] (SPARK-23655) Add support for type aclitem (PostgresDialect)
[ https://issues.apache.org/jira/browse/SPARK-23655?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16411485#comment-16411485 ] Diego da Silva Colombo commented on SPARK-23655: [~maropu] I feel it too, it's look like a awkward type for spark, but unfortunately the table I'm trying to access is managed by postgres, so I cannot change it type. I've made a workaround by creating a custom JdbcDialect, and returning a StringType on toCatalystType. For my case it worked, but if you try to access the aclItem column an exception occurs. If you don't think this is a useful thing for spark, feel free to close the issue. Thanks for the attention > Add support for type aclitem (PostgresDialect) > -- > > Key: SPARK-23655 > URL: https://issues.apache.org/jira/browse/SPARK-23655 > Project: Spark > Issue Type: Improvement > Components: SQL >Affects Versions: 2.3.0 >Reporter: Diego da Silva Colombo >Priority: Major > > When I try to load the data of pg_database, an exception occurs: > `java.lang.RuntimeException: java.sql.SQLException: Unsupported type 2003` > It's happens because the typeName of the column is *aclitem,* and there is no > match case for thist type on toCatalystType -- This message was sent by Atlassian JIRA (v7.6.3#76005) - To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org
[jira] [Created] (SPARK-23655) Add support for type aclitem (PostgresDialect)
Diego da Silva Colombo created SPARK-23655: -- Summary: Add support for type aclitem (PostgresDialect) Key: SPARK-23655 URL: https://issues.apache.org/jira/browse/SPARK-23655 Project: Spark Issue Type: Improvement Components: SQL Affects Versions: 2.3.0 Reporter: Diego da Silva Colombo When I try to load the data of pg_database, an exception occurs: `java.lang.RuntimeException: java.sql.SQLException: Unsupported type 2003` It's happen because the typeName of the column is *aclitem,* and there is no match case for thist type on toCatalystType -- This message was sent by Atlassian JIRA (v7.6.3#76005) - To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org
[jira] [Updated] (SPARK-23655) Add support for type aclitem (PostgresDialect)
[ https://issues.apache.org/jira/browse/SPARK-23655?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Diego da Silva Colombo updated SPARK-23655: --- Description: When I try to load the data of pg_database, an exception occurs: `java.lang.RuntimeException: java.sql.SQLException: Unsupported type 2003` It's happens because the typeName of the column is *aclitem,* and there is no match case for thist type on toCatalystType was: When I try to load the data of pg_database, an exception occurs: `java.lang.RuntimeException: java.sql.SQLException: Unsupported type 2003` It's happen because the typeName of the column is *aclitem,* and there is no match case for thist type on toCatalystType > Add support for type aclitem (PostgresDialect) > -- > > Key: SPARK-23655 > URL: https://issues.apache.org/jira/browse/SPARK-23655 > Project: Spark > Issue Type: Improvement > Components: SQL >Affects Versions: 2.3.0 >Reporter: Diego da Silva Colombo >Priority: Major > > When I try to load the data of pg_database, an exception occurs: > `java.lang.RuntimeException: java.sql.SQLException: Unsupported type 2003` > It's happens because the typeName of the column is *aclitem,* and there is no > match case for thist type on toCatalystType -- This message was sent by Atlassian JIRA (v7.6.3#76005) - To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org