Welcome, Guest
Username: Password: Remember me
Data Warehousing and Data integration
  • Page:
  • 1

TOPIC: Extracting data from hadoop

Extracting data from hadoop 7 months 21 hours ago #17819

  • Anthony
  • Anthony's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 7
  • Thank you received: 0
Hello

I had a look at the list of supported datasources and I could not find hadoop cluster.
Is it supported?

Please Log in or Create an account to join the conversation.

Extracting data from hadoop 7 months 20 hours ago #17822

Hi Antony

This can be easily done by using hadoop ODBC driver.

On the MapR doc website, go to Install the Hive ODBC Connector on Windows. The instructions provide a link to download the driver package.
Download the package for your Windows environment.
Follow the instructions for installing the ODBC connector.

www.mapr.com/doc/display/MapR/Hive+ODBC+Connector

Please Log in or Create an account to join the conversation.

Extracting data from hadoop 4 days 21 hours ago #18840

Hello Antony,
I suggest you to use hadoop ODBC Driver .
download the installation package and double click on the HiveODBCSetupx64.msi to install HiveODBC x64, x86, and the Excel Hive Add-in. Now install the Excel Hive Add-in, click OK and give it a try! To verify the install worked, click on the Data tab in Excel and you should see the Hive Pane as below. Using the Excel Hive Add-in, click on the Hive Pane and on the right side of the main Excel window, the Hive pane will become visible for you to begin querying your Hadoop Big Data sources.

Please Log in or Create an account to join the conversation.

  • Page:
  • 1

We have 787 guests and no members online