About asish

asish · ‎11-19-2022

hi @Raed_Faly You need discipline with > 10 gold medals Please use below query and check: select distinct t.discipline, m.team from teams t join medals m on (t.noc=m.team and m.numbergold>10) order by m.team asc limit 5; select distinct t.discipline, m.team from teams t join medals m on (t.noc=m.team and m.numbergold>10) order by m.team desc limit 5; Please "Accept As Solution", if your queries are answered.

asish · ‎11-19-2022

@NikoBelic Thanks for the update. The hive metadata indeed is stored on database. You need to take the dump to backup the metadata. Please let me know,if you have nay queries. Please "Accept as Solution" ,if your queries are answered.

asish · ‎11-16-2022

@NikoBelic VIEWS are stot=red in TBLS table i.e in Hive metadata. You can create a database dump as a backup. Please follow https://dev.mysql.com/doc/refman/8.0/en/mysqldump.html to create database dump for mysql Please follow https://www.postgresql.org/docs/current/backup-dump.html to create database dump for postgres Please let me know,if you have any queries. Please "Accept As Solution", if your queries are answered.

asish · ‎11-15-2022

@NikoBelic Could you please elaborate your issue? Do you want to secure Hive Views using Ranger authorisation? Is this your requirement?

asish · ‎11-14-2022

As there are lot many partitions,so DROP command would time out. You must remove the partitions using below command: You need to drop partition manually https://stackoverflow.com/questions/13815179/how-to-update-drop-a-hive-partition Then invoke drop table. Drop command times out owing to lot many partitions.

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-13-2022

Run the equivalent query in beeline and share the below if you encounter the error: 1. beeline trace => This should contain queryID and query 2. HS2 logs 3. application log This will help us to analyse

asish · ‎11-12-2022

Please set hive.fetch.task.conversion=more, and try the query hive.fetch.task.conversion=none, and try the query

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

Online	Offline
Last Visited	‎12-23-2024 05:29 AM

Member Since	‎11-11-2019 12:46 AM
Last Visited	‎12-23-2024 05:29 AM
Posts	610
Kudos received	26

Cloudera Community

Re: hive vertex error unknown cause.

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

Re: Data not inserting in hive table (CDP)

Re: Hiveserver2 on Tez can't start after enable ke...

Re: Hive error:java.lang.OutOfMemoryError: Java he...

Re: Hive

Re: How are you protecting Hive views

Re: How are you protecting Hive views

Re: How are you protecting Hive views

Re: Hive external table MSCK and DROP not working....

Re: Configure HA database for Hive Metastore

Re: hive pyspark integration

Re: hive pyspark integration

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

Re: Query Hive Using Python Getting below error