0 votes
1 view
in Big Data Hadoop & Spark by (31k points)
Can anyone tell me how to query Hadoop from the SQL server?

1 Answer

0 votes
by (29.6k points)

In SQL Server Management Studio we can now create a linked server connection to the Hadoop system using the following command:

EXEC master.dbo.sp_addlinkedserver     

@server = N'Hadoop',     

@srvproduct=N'HIVE',     

@provider=N'MSDASQL',     

@N'HDP',     

@provstr=N'Provider=MSDASQL.1;Persist Security Info=True;User ID=hue;'

Depending on your Hadoop’s security settings, you might need to provide a password for the provider string as well

In order to run a query, you can use one of the following commands:

select * from openquery (Hadoop, 'select * from table_name')

or

select * from [Hadoop].[HIVE].[default].[table_name]

If you want to learn Hadoop, I recommend this Hadoop Training program by Intellipaat.

Welcome to Intellipaat Community. Get your technical queries answered by top developers !


Categories

...