[jira] [Updated] (HIVE-9991) Cannot do a SELECT on external tables that are on S3 due to Encryption error

["Sergio Peña (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HIVE-9991?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Sergio Peña updated HIVE-9991:
------------------------------
    Attachment: HIVE-9991.1.patch

> Cannot do a SELECT on external tables that are on S3 due to Encryption error
> ----------------------------------------------------------------------------
>
>                 Key: HIVE-9991
>                 URL: https://issues.apache.org/jira/browse/HIVE-9991
>             Project: Hive
>          Issue Type: Bug
>    Affects Versions: 1.0.0
>            Reporter: Sergio Peña
>            Assignee: Sergio Peña
>         Attachments: HIVE-9991.1.patch
>
>
> I cannot do any select query on external tables that are not part of HDFS. For example S3.
> {code}
> Select * from my_table limit 10;
> FAILED: SemanticException Unable to determine if s3n://my-bucket/is encrypted: java.lang.IllegalArgumentException: Wrong FS: s3n://my-bucket/, expected: hdfs://0.0.0.0:8020
> {code}
> This error is due to a internal function that checks if a table is encrypted or not. This is only supported on HDFS files, but the check is happening on any external table as well causing the above error.
> To fix this, we should check for encrypted tables only for HDFS tables. And skip the check for any other file schema.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)