SQL Developer for Big Data
source link: https://medium.com/sanrusha-consultancy/sql-developer-for-big-data-30122c8ceb6b
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
SQL Developer for Big Data
Instructions on running HiveQL on Oracle SQL Developer
In this article, I will take you through the steps to connect SQL Developer with Hive.
By default, SQL developer doesn’t contain HIVE drivers. You can download it from providers like Cloudera. At the time of writing this article, the latest JDBC driver version was 2.6.5.
Unzip the driver. Open SQL Developer and go to Tools>Preferences.
In the Preferences, expand Database Option and click on Third Party JDBC Driver. Click on Add Entry button and select the .jar file.
You are all done. Click on OK button.
Click on New Connection and you should see Hive Tab!
Congratulations!
You are all set! Happy connecting to Hive and running HiveQL in SQL developer!
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK