Created on 03-16-2015 06:39 PM - edited 09-16-2022 02:24 AM
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?
Created 03-17-2015 11:39 AM
Created 04-28-2015 09:02 AM
Created 03-17-2015 11:39 AM
Created 03-17-2015 03:39 PM
Thank you for telling me this, you really save my day!
Created 03-17-2015 03:43 PM
Created 04-07-2015 05:12 PM
How to downgrade?
By following the http://www.cloudera.com/content/cloudera/en/documentation/core/v5-2-x/topics/cdh_ig_install_previous...
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
Created 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
Created 04-28-2015 09:02 AM
Created 04-30-2015 12:24 PM
Thanks, I'll upgrade my cluster and try it again
Created 07-07-2015 08:59 AM
This is still not working for me. I am currently using cdh-5.4.3 for hive and impala
Created on 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