About smruti

VidyaSargur · ‎08-24-2022

@ssuja, Has the reply helped resolve your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future.

xinghx · ‎08-08-2022

I didn't notice that the property "external" is case sensitive,the step 2 should be ALTER TABLE alter_test SET TBLPROPERTIES('EXTERNAL'='false'); ,then the location would be changed in CDP7.1.1. And In CDP 7.1.7, It does not work even if I set property "TRANSLATED_TO_EXTERNAL" to true after creating table ,could you try the steps and give an attachment? thanks.

DianaTorres · ‎08-04-2022

@Imran_chaush Has the reply helped resolve your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future. Thanks

newbieone · ‎07-15-2022

Could help to explain what's the meaning of first 2 sentence? Set Hive..... What would happen if we don't have 2 sentences? How would that impact our query? Thanks.

mattyseltz · ‎04-05-2022

Don't know, yet, have not had time to investigate.

Ging · ‎04-03-2022

Thank you. We contacted Liquibase. Unfortunately, they don't have a built-in extension of Hive/Impala extension. Though they promise to look into this requirement in more detail. Hopefully, they come-up with a solution soon.

smruti · ‎12-16-2021

@Gcima009 are you trying to collect the logs with the same user that you submitted the job with? This query completed the map phase, and failed in reducer phase. If you are not able to collect the app logs, do check the HS2 log with the query ID hive_20211210173528_ff76c3df-a33b-41d0-b328-460c9b65deda if you get more information what caused the job to fail.

hxn · ‎12-02-2021

There is also an option of "Supported TLS versions" in Cloudera Manager under Security, search for SSL you will get the option of "Supported TLS versions" even after selecting TLSv1.2 from that option our security scans show that few ports from impala and some other services are open. Screenshot of Cloudera Manager is attached. Regards Hxn

VidyaSargur · ‎11-17-2021

@HareshAmin, Has the reply helped resolve your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future.

smruti · ‎11-14-2021

@mhchethan Yes, you could mention multiple LDAP URLs separated by spaces. Hive will try the URLs in the mentioned order until a connection is successful. Ref: hive.server2.authentication.ldap.url

Online	Offline
Last Visited	‎10-10-2025 03:01 AM

Member Since	‎10-28-2020 05:19 AM
Last Visited	‎10-10-2025 03:01 AM
Posts	622
Kudos received	46

Cloudera Community

Re: I have a HIVE table which contains JSON as a c...

Re: ANALYZE command not write data into hive metas...

Re: HBase stores base64 data when data is inserted...

Re: Deleting hive service on CDP Private Base and ...

Re: Not Able to run import command. it fails with ...

Re: How to give access to users to create and own ...

Re: hive 执行rename后，表的location没有相应发生改变

Re: How Many User using Hive DB and Table

Re: Hive partitioning

Re: Hortonworks odbc SSL handshake error

Re: Managing Hive Schema Changes

Re: Execution Error, return code 1 from org.apache...

Re: Enforce TLSv1.2 for CDP working with AutoTLS

Re: Impala Not supporting org.apache.hadoop.hive....

Re: Configuring Multiple LDAP at hive