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?
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
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
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