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/Gowthamsb12/hive/b...
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 : atozknowledge.com@gmail.com
LinkedIn : / sbgowtham
Instagram: / bigdata.in
KZread channel link
/ atozknowledgevideos
Website
atozknowledge.com/
Technology in Tamil & English
#apachehive

Пікірлер: 19

  • @sasidharans8431
    @sasidharans84313 жыл бұрын

    Thank you so much for your time👍

  • @akarshsharma2177
    @akarshsharma21772 жыл бұрын

    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

  • @abhishekn786
    @abhishekn786 Жыл бұрын

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

  • @luctiber
    @luctiber3 жыл бұрын

    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

    @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.

  • @bhavitavyashrivastava8600
    @bhavitavyashrivastava8600 Жыл бұрын

    pllease provide configuration for tez and spark as hive engine

  • @ashwinkumar5223
    @ashwinkumar5223 Жыл бұрын

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

  • @ksansudeen
    @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

  • @surajpatil3579
    @surajpatil35792 жыл бұрын

    This is helpful

  • @therajlalrs1460
    @therajlalrs1460 Жыл бұрын

    Windows installation process podunga bro

  • @archanam4224
    @archanam42242 жыл бұрын

    thanks a lot

  • @kunjanbarot7374
    @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

  • @Kutub2005
    @Kutub20052 жыл бұрын

    geat tutorials

  • @kranthikiran5392
    @kranthikiran53922 жыл бұрын

    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

  • @user-qv6oi7yl1w

    @user-qv6oi7yl1w

    2 жыл бұрын

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

  • @user-qv6oi7yl1w

    @user-qv6oi7yl1w

    Жыл бұрын

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

  • @rakeshbabu3839

    @rakeshbabu3839

    Жыл бұрын

    Did you solve the error?

Келесі