About asish

asish · ‎11-14-2022

@KPG1 I can think of Oracle database ha a feature i.e Oracle RAC,where we give SCAN address as the jdbc string to metastore,so the scan ip wll take care of loadbalancing. You need to check with mysql vendor(Oracle),if they have similar thing as of Oracle database. You can have HMS HA but all the HMS instance point to same database, you can not have 2 HMS instance pointing to a different database. Please let me know,if you have any querties and please "Accept As Solution", if your queries are answered

asish · ‎11-11-2022

You can set tez.grouping.max-size to 1gb. Please increase below set hive.tez.container.size=10240; set tez.runtime.io.sort.mb=4096; (40% of container size)

asish · ‎11-11-2022

thank you @pankshiv1809

asish · ‎11-11-2022

@octor You can tewk the split sizes if you are using Tez. set tez.grouping.min-size=16777216;--16 MB min split set tez.grouping.max-size=64000000;--64 GB max split

asish · ‎11-11-2022

@pankshiv1809 were you able to fix? Please click "Accept as solution" if this has worked

asish · ‎11-10-2022

This seems to be more of Spark. But I see below error: java.io.FileNotFoundException: File does not exist: /warehouse/tablespace/external/hive/dim_cd_db.db/dim_subs_language_ivr/circle_id=14/part-00000-f53b4b78-8256-4040-9195-7af54c3365c8.c000.snappy.orc Can you please check,if the file is present: hdfs dfs -ls/warehouse/tablespace/external/hive/dim_cd_db.db/dim_subs_language_ivr/circle_id=14/part-00000-f53b4b78-8256-4040-9195-7af54c3365c8.c000.snappy.orc Please also perfrom and let us know msck repair table dim_subs_language_ivr Try to run the same in hive beeline and check if the issue persists.

asish · ‎11-10-2022

@octor I see you have already raised https://issues.apache.org/jira/browse/HIVE-26720 May I know why do you want to change stripe size?

asish · ‎11-10-2022

@pankshiv1809 I see you are getting Spark related error . Are you using Spark or Hive query ?

asish · ‎11-04-2022

@chengxi Are you using CDP ? replicate the issue and provide /var/log/hive/ /var/run/cloudera-scm-agent/process/<hive that crashed>/logs

asish · ‎08-12-2022

@mareb Can you please attach application logs for application_1657267798389_0085

Online	Offline
Last Visited	‎05-01-2026 04:20 AM

Member Since	‎11-11-2019 12:46 AM
Last Visited	‎05-01-2026 04:20 AM
Posts	636
Kudos received	27

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: Configure HA database for Hive Metastore

Re: How to set orc.stripe.size value in hive table...

Re: Query Hive Using Python Getting below error

Re: How to set orc.stripe.size value in hive table...

Re: Query Hive Using Python Getting below error

Re: Query Hive Using Python Getting below error

Re: How to set orc.stripe.size value in hive table...

Re: Query Hive Using Python Getting below error

Re: kerberos fails to be installed and hive cannot...

Re: HIVE MAJOR Compaction fails for one specific p...