In SQL Server Management Studio we can now create a linked server connection to the Hadoop system using the following command:
@server = N'Hadoop',
@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')
select * from [Hadoop].[HIVE].[default].[table_name]
If you want to learn Hadoop, I recommend this Hadoop Training program by Intellipaat.