I’m trying to apply SSAS onto local single node Hive. First problem I’ve encounter here is that I cannot find Hive data source in the ODBC data source list.
I did all the steps provided by online materials.
And set up a Hive ODBC Data Source Name, configure Host & Port correctly. Also when I click “Test” button in Figure 1, it pops up the Microsoft Hive ODBC Driver Data Source Test window as Figure 2, telling me connection is successful. However, when I try to test it manually in Excel, add data source, I cannot find the Hive Data source I just created. I’ve already tried to restart my computer, yet still not working.
I’m new to this. Would you please help me out here? Many thanks.