03-16-2015 06:39 PM
After I upgrade from CDH 5.3.1 to CDH 5.3.2, and then run "select" SQL queries, it gives me some errors:
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://us0701aohc172018080109.tangome.gbl:8020
I tryied to drop my table and re-create it again add partitions to it, then run select queries, still the same error. Before upgrading everything is OK.
Does anybody happen to know why?
03-17-2015 11:39 AM
04-07-2015 05:12 PM
How to downgrade?
It does not work for me. I am using ubuntu trusty.
Although I specified the 5.3.1 version, apt-get install hive failure.
If I do not specified the version, it will install 5.3.2
04-28-2015 04:46 AM
have the same issue on an external table in CDH 5.3.3
Error while compiling statement: FAILED: SemanticException Unable to determine if hdfs://cdhtest/store/TPCH3TB/lineitem is encrypted: java.lang.IllegalArgumentException: Wrong FS: hdfs://cdhtest/store/TPCH3TB/lineitem, expected: hdfs://pupa
any workaround ? is it fixed in 5.4
07-20-2015 09:21 AM - edited 07-20-2015 09:40 AM
Despite the above comments about 5.3.3 and 5.4.0, this issue is not fixed in those versions. According to the comments from Jim B on a related thread of mine ( http://community.cloudera.com/t5/Batch-SQL-Apache-Hive/Loading-to-S3-Fails-CDH-5-3-0/m-p/24088#U2408... ) this _IS_ fixed in 5.4.4