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!!
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
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
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
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
![Hive SQL [Create| Load| Insert | Show]](http://i.ytimg.com/vi/AXvGkP20CDs/mqdefault.jpg)
![Hive SQL [Create| Load| Insert | Show]](/img/tr.png)
![Installation [Apache Hive 2 with MySQL]{தமிழ்} #hive #apachehive](http://i.ytimg.com/vi/AVNAKkeCEWo/mqdefault.jpg)
Thanks for the tutorial,
How to setup hive on Hadoop edge node?
hi I have doubt on hdfs is it possible to update file that is stored in hdfs
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!!
just got to your hive/lib and search for log4j-slf4j-impl and just delete this jar file, you will be good to go.
Thank you so much for your time👍
Could you please upload one video install hive and pig in windows
Windows installation process podunga bro
pllease provide configuration for tez and spark as hive engine
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
This is helpful
geat tutorials
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
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!
Did you solve the error?
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