[jira] [Updated] (HIVE-9991) Cannot do a SELECT on external tables that are on S3 due to Encryption error
[
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.2.patch
New patch with just a small changes:
- Change equals() to equalsIgnoreCase()
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, HIVE-9991.2.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)
[jira] [Updated] (HIVE-9991) Cannot do a SELECT on external tables that are on S3 due to Encryption error
[
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.3.patch
Fixed patch to include the test into TestEncryptedHdfsCliDriver tests.
It also uses pfile:/// as a location instead of file:/// in order to avoid
change ownership errors.
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, HIVE-9991.2.patch, HIVE-9991.3.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)
[jira] [Updated] (HIVE-9991) Cannot do a SELECT on external tables that are on S3 due to Encryption error
[
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)
