Hello all! Has anyone successfully connected to Hive via Windows Powershell? We've connected to both ORACLE and MSSQL databases via ODBC connections quite easily in the past, but we're having a hard time finding any documentation/code for connecting to Hive via Windows Powershell. We currently don't have any Azure subscriptions, so Azure Powershell/HdInsight is off the table. Thanks for your time! ... View more

Hello! I have been stuck on this issue for a few days and am at a complete standstill as to what I can do next. Here is a description of my problem. There are four tables imported into Hive with multiple data points. Unfortunately, the only join-able key is employee names. The problem with this key is that the names are spelled differently/formatted differently across data sources. I downloaded a fuzzy match UDF, but I'm having a hard time LEFT OUTER JOINING the tables onto each other using the fuzzy match UDF because the results are non-equality. I'm looking for suggestions on how to join these tables onto each other in HIVE without inner joining. I would do this on the server side sql, but these tables are from different data sources/databases. Thanks for the help! ... View more

Hi there! I'm quite new to Hortonworks and have been working to install a function in the sandbox for 2.6.3. I have a Hive UDF that I can run in the CLI under the root user with no issue, but when I try to use the function in a query with the Maria_dev user in Ambari, it says the function does not exist. I've used both create temporary and create function options, and I can see both the temporary and full functions in the CLI, but still can't query against it in the Ambari user. I can run a query using the function in the HIve CLI with the root user with no issue. I thouight that I created the standard function, without it being temporary, that it would carry over to the other users for permission. Any guidance is much appreciated! ... View more