Installation [ Apache Hive 2 with MySQL ]

Hive single node setup , in this video I have explained how to configure hive with mysql metastore
Hive-site.xml - github.com/Gow...
Video Playlist
-----------------------
Hive in Tamil - bit.ly/2UQVUgv
Hive in English - bit.ly/372nCwj
Hadoop in Tamil - bit.ly/32k6mBD
Hadoop in English - bit.ly/32jle3t
Spark in Tamil - bit.ly/2ZzWAJN
Spark in English - bit.ly/3mmc0eu
Batch vs Stream processing Tamil - • Data - Batch processi...
Batch vs Stream processing English - • Data - Batch processi...
NOSQL in English - bit.ly/2XtU07B
NOSQL in Tamil - bit.ly/2XVLLjP
Scala in Tamil: goo.gl/VfAp6d
Scala in English: goo.gl/7l2USl
Email : [e-mail]
LinkedIn : / sbgowtham
Instagram: / bigdata.in
UA-cam channel link
/ atozknowledgevideos
Website
atozknowledge.com/
Technology in Tamil & English
#apachehive

[@luctiber]

Hi, thanks for sharing such great hands on experience. I am facing an issue with the set up of hive on a windows 10 pc. It sounds like there are multiple log4j and slf4g causing some trouble ... at the end hive does not start. Could you point me to a direction (any...). I’ve been trying almost anything (adding,removing...) but nothing seems to fix the issue! Thanks and keep the good work!!

[@SarikaYadav86]

just got to your hive/lib and search for log4j-slf4j-impl and just delete this jar file, you will be good to go.

[@sasidharans8431]

Thank you so much for your time👍

[@abhishekn786]

Thanks for the tutorial,
How to setup hive on Hadoop edge node?

[@ashwinkumar5223]

Could you please upload one video install hive and pig in windows

[@surajpatil3579]

This is helpful

[@therajlalrs1460]

Windows installation process podunga bro

[@akarshsharma2177]

hi, when i tried to launch HIVE it threw an error : log4j:ERROR Could not instantiate class [org.apache.hadoop.hive.shims.HiveEventCounter].
Can you pls help.. Thanks

[@bhavitavyashrivastava8600]

pllease provide configuration for tez and spark as hive engine

[@ksansudeen]

I see , some mysql DB grant commands are missing in the vide.
The following command "GRANT PREVILIGES ON*.* TO '*****hiveuser***'@'localhost' " should be execute to create hive schema in mysql

[@archanam4224]

thanks a lot

[@Kutub2005]

geat tutorials

[@kranthikiran5392]

org.apache.hadoop.hive.metastore.HiveMetaException: Failed to get schema version.
Underlying cause: java.sql.SQLException : Access denied for user 'root'@'localhost'
I am getting this error when I run bin/schematool -dbType mysql -initSchema

[@ทรงภพศาลติกุลนุการ]

I have the same error too and in my conf/ i don't have hive-site.xml in this directory as well

[@ทรงภพศาลติกุลนุการ]

I fix all the errors and can use hive like gowtham now cheers!

[@rakeshbabu3839]

Did you solve the error?

[@kunjanbarot7374]

Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
org.apache.hadoop.hive.metastore.HiveMetaException: Failed to get schema version.
Underlying cause: java.sql.SQLException : Access denied for user 'root'@'localhost'
SQL Error code: 1698
Use --verbose for detailed stacktrace.
*** schemaTool failed ***
return this error can anyone help me out this