[
https://issues.apache.org/jira/browse/SPARK-23655?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=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
