About asish

asish · ‎09-28-2021

@David2 does the file exist?? What kind of file is this? Please share the DDL for the table. Please also share the application logs of the failed job Share application logs for the failed compaction job too.

asish · ‎09-28-2021

@Venk123 I think you are hitting https://issues.apache.org/jira/browse/HIVE-3363 I would request to raise case to get it verified and if verified you would receive a patch.

VidyaSargur · ‎09-27-2021

@nareshbattula, Has any of the replies 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 · ‎09-25-2021

@mailsmail I am afraid authorisation tools might not be able to help us here. HIVE-18755 is talking about having two separate catalogs named hive and spark, under Hive metastore db for Hive and Spark services respectively. Here, you could either create databases with different names, or have multiple metastore instances, pointing them to different HMS databases. Then, you will need to have individual HS2 instance(with help of Config groups) connecting to separate Metastores.

asish · ‎09-22-2021

You have to use com.cloudera.hive.jdbc.HS2Driver class for the driver. I don't have expertise on Websphere ,I can not help with JNDI.

VidyaSargur · ‎09-21-2021

Hi @dv_conan Has any of the replies 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. If you are still experiencing the issue, can you provide the information that is requested?

asish · ‎09-16-2021

@Sayed016 This error occurs if the HDFS files are under replicated. Did you see HDFS is under replicated when the issue occurred? Wait for the HDFS to gets replicated and you can query

asish · ‎09-09-2021

DISTCP or import/export is not supported for ACID tables. You need to follow below mechanism: Distscp for ACID is not supported ,you have 2 approaches: Approach 1 ============= 1. Assuming that you have ACID in source and target clusters. 2. Create a external in source and target clusters. 3. Copy the data from ACID TO external in SOURCE CLUSTER INSERT into external select * from acid. 4. Perfrom distscp from source to target for external table. 5. Copy the data from external TO ACID IN SOURCE CLUSTER INSERT into acid select * from external. Approach 2 ========= Use DLM Refrence: https://community.cloudera.com/t5/Support-Questions/HIVE-ACID-table-Not-enough-history-available-for-0-x-Oldest/td-p/204551

RangaReddy · ‎08-31-2021

Hi @yudh3 This application is deployed first time or it is an existing application. If it is first time then you need to tune according to what kind of operation you are doing. If an existing application, this issue is occurring recently or from long time it is there. If it is occurring recently, is there any data change or any hdfs/hive issues. Without understanding the logs, difficult to tell what is the exact issue. Please go ahead and create a case for this issue, we will work on.

VidyaSargur · ‎08-30-2021

Thanks for the confirmation @syedshakir. Much appreciated.

Online	Offline
Last Visited	‎10-29-2025 05:13 AM

Member Since	‎11-11-2019 12:46 AM
Last Visited	‎10-29-2025 05:13 AM
Posts	634
Kudos received	26

Cloudera Community

Re: Impala's log "ORC read request to already read...

Re: DBeaver connection issue with CDP Hive.

Re: hive vertex error unknown cause.

Re: ERROR: Connecting to Kerberos Enabled Hive usi...

Re: Data not inserting in hive table (CDP)

Re: Hive transaction table compacte delta file err...

Re: Hive - Special characters from csv file

Re: How do we identify hive metastore performance ...

Re: Multi-Tenancy in Hive Metastore

Re: Setup Hive Datasource in IBM WebSphere

Re: Hue Not working with hive on tez

Re: yRe: [Hive] IOException: Fail to get checksum,...

Re: hive tez query error

Re: hive on spark job suddenly runs abnormally slo...

Re: You can't execute queries until the end of the...