You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Rajkumar Singh (JIRA)" <ji...@apache.org> on 2019/06/17 16:12:00 UTC
[jira] [Commented] (HIVE-21883) Cannot use CTAS for managed table
backed by Druid for Hive on Spark
[ https://issues.apache.org/jira/browse/HIVE-21883?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16865735#comment-16865735 ]
Rajkumar Singh commented on HIVE-21883:
---------------------------------------
look like druid-storage handler is missing at runtime, can you try adding the druid-handler*.jar to spark executor classpath and see if that works?
> Cannot use CTAS for managed table backed by Druid for Hive on Spark
> -------------------------------------------------------------------
>
> Key: HIVE-21883
> URL: https://issues.apache.org/jira/browse/HIVE-21883
> Project: Hive
> Issue Type: Bug
> Components: Druid integration
> Affects Versions: 2.3.5
> Environment: Hive version: 2.3.5
> Druid version: 0.14.2
> Execution engine Spark: 2.4.1
> Reporter: Peeranut Ngaorungsri
> Priority: Major
> Attachments: error_from_hive_server.txt
>
>
> Run the following CTAS:
> "CREATE TABLE district
> STORED BY 'org.apache.hadoop.hive.druid.DruidStorageHandler'
> AS SELECT dt_cre as `__time`, dis_code, dis_desc FROM finwiz_cdc.tu_district"
>
> PS1. Where dt_cre is timestamp, dis_code and dis_desc are string.
> PS2. Please find an attached error from hive
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)