How can I connect Spark SQL to Hive 0.13.1?

Asked by Last Modified  

1 Answer

Learn Hadoop

Follow 1
Answer

Please enter your answer

Gopal Raj

Big Data Architect

We can take that one step further an make the Hive tables available through Spark SQL via JDBC from outside the cluster. SPARK_HOME/sbin/start-thriftserver.sh --hiveconf hive.server2.thrift.port={port to listen} --hiveconf hive.server2.thrift.bind.host={host to bind to} --master yarn-client This will...
read more
We can take that one step further an make the Hive tables available through Spark SQL via JDBC from outside the cluster. SPARK_HOME/sbin/start-thriftserver.sh --hiveconf hive.server2.thrift.port={port to listen} --hiveconf hive.server2.thrift.bind.host={host to bind to} --master yarn-client This will start a HiveServer2 instance that has access to the meta store but will turn SQL into Spark instruction sets and RDDs under the covers. You should now be able to use a HiveServer compliant JDBC driver to connect and access the power of SparkSQL and yet leverage all of the existing investment and assets in Hive read less
Comments
Dislike Bookmark

Related Questions

Hi... I am working as linux admin from last 2 yr. Now I want to peruse my career in Big Data hadoop. Please let me know what are opportunities for me and is my experience considerable and what are the challenges.
Hi Vinay, My friend moved from Linux admin to Handoop admin role with very good jump in his career. Definitely it is good move to jump to Hadoop from Linux Admin. Linux Admin market is tough as many...
Vinay Buram
Hello, I have completed B.com , MBA fin & M and 5 yr working experience in SAP PLM 1 - Engineering documentation management 2 - Documentation management Please suggest me which IT course suitable to my career growth and scope in market ? Thanks.
If you think you are strong in finance and costing, I would suggest you a SAP FICO course which is definitely always in demand. if you have an experience as a end user on SAP PLM / Documentation etc, even a course on SAP PLM DMS should be good.
Priya
1 0
9
How many nodes can be there in a single hadoop cluster?
A single Hadoop cluster can have **thousands of nodes**, depending on hardware and configuration.
Tahir
0 0
7
Can anyone suggest about Hadoop?
Hadoop is good but it depends on your experience. If you don't know basic java, linux, shell scripting. Hadoop is not beneficial for you.
Ajay
What are some of the best blogs for Hadoop?
DBMS2 is the best personal database and analytics blog. Hortonworks’ blog is a must-read for Hadoop users. Cloudera also maintains an important Hadoop blog.
Rahul

Now ask question in any of the 1000+ Categories, and get Answers from Tutors and Trainers on UrbanPro.com

Ask a Question

Related Lessons

CheckPointing Process - Hadoop
CHECK POINTING Checkpointing process is one of the vital concept/activity under Hadoop. The Name node stores the metadata information in its hard disk. We all know that metadata is the heart core...

Silvia Priya

0 0
0
How Big Data Hadoop and its importance for an enterprise?
In IT phrasing, Big Data is characterized as a collection of data sets (Hadoop), which are so mind boggling and large that the data cannot be easily captured, stored, searched, shared, analyzed or visualized...

Prwatech

1 0
0
Big DATA Hadoop Online Training
Course Content for Hadoop DeveloperThis Course Covers 100% Developer and 40% Administration Syllabus.Introduction to BigData, Hadoop:- Big Data Introduction Hadoop Introduction What is Hadoop? Why Hadoop?...

Websoft Technologies

0 0
0
Up, Up And Up of Hadoop's Future
The onset of Digital Architectures in enterprise businesses implies the ability to drive continuous online interactions with global consumers/customers/clients or patients. The goal is not just to provide...

Gopal Raj

0 0
0
How To Be A Hadoop Developer?
i. Becoming a Hadoop Developer: Dice survey revealed that 9 out of 10 high paid IT jobs require big data skills. A McKinsey Research Report on Big Data highlights that by end of 2018 the demand for...

Amit raj

1 0
0

Recommended Articles

Some Popular IT Courses in Current Market

In the domain of Information Technology, there is always a lot to learn and implement. However, some technologies have a relatively higher demand than the rest of the others. So here are some popular IT courses for the present and upcoming future: Cloud Computing Cloud Computing is a computing technique which is used...

Read full article >

Learn Hadoop and Big Data

Hadoop is a framework which has been developed for organizing and analysing big chunks of data for a business. Suppose you have a file larger than your system’s storage capacity and you can’t store it. Hadoop helps in storing bigger files than what could be stored on one particular server. You can therefore store very,...

Read full article >

Growth and Career Prospects in Big Data

Big data is a phrase which is used to describe a very large amount of structured (or unstructured) data. This data is so “big” that it gets problematic to be handled using conventional database techniques and software.  A Big Data Scientist is a business employee who is responsible for handling and statistically evaluating...

Read full article >

Why Should you Become a Data Scientist

We have already discussed why and how “Big Data” is all set to revolutionize our lives, professions and the way we communicate. Data is growing by leaps and bounds. The Walmart database handles over 2.6 petabytes of massive data from several million customer transactions every hour. Facebook database, similarly handles...

Read full article >

Find Hadoop near you
Hadoop in Hyderabad

Looking for Hadoop ?

Learn from the Best Tutors on UrbanPro

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you