In addition, for the live sessions, it was really a joy attending them each weekend, our instructor “Sandeep Giri”, besides his great experience and knowledge, he was generous, helpful and patient answering all attendees questions in such a way that he could go for more examples and hands-on or even searching the documentation and try new things, I gained much from other attendees’ questions and the way Sandeep responded to them.
There were always exercises and hands-on that build better understanding, also the lab environment and provided online tools were great help and let you practice everything without having to install anything on your PC except the web browser. The course structure and topics were great, well organized and comprehensive, even the basics of Linux were covered in a very simple way. I completed the “Big Data with Spark” course and the learning journey really exceeded my expectations. Let me know if it Ahmad Below steps will help you in setting up ODBC.I have started learning 3 months ago and I really gained much info and practical experience. On the Add-Ons page, scroll down to Hortonworks Hive ODBC Driver (Windows + Mac) and select the driver that matches the version of Excel installed on your system (32-bit or 64-bit). The architecture will be detected and the correct package will be automatically installed by the Homebrew formula. Apple M1 (ARM64) support was added starting with version 17.8.
In case of LDAP pass username/password with auth as username and password. of 14 Installing and Configuring the Hortonworks ODBC driver on Windows 7 2. The Microsoft ODBC driver for SQL Server on macOS is only supported on the 圆4 architecture through version 17.7. Check property value, if it is None, you can set Authentication Mechanism in ODBC config as just Username and pass the end user otherwise if it is Kerberos, you can set Kerberos for it. I would check FQDN of HS2 host from end client and set the same in Host for ODBC.ģ. Test the connectivity between end Client and Hiveserver2 host by using ping or telnet on the port we got from above point.
If it is binary then set Thrift Transport mode to default SASL.Ģ. However, it is recommended to use the Amazon ODBC driver for Amazon Hive and the Hortonworks ODBC driver for HortonWorks Hive.
If the above is set to binary, in that case, your Hiveserver2 is running on Binary Mode i.e based on above configs it should be port 10000, otherwise, if it is HTTP then your HS2 is running on PORT 10001įor HTTP Transport mode, set transport mode as HTTP and HTTP Path as cliservice When you set up the connection follow the advice above, so you can test it easily. The Amazon and HortonWorks ODBC drivers are similar and compatible to work with Hive 2.x release. Check on what Mode my Hiveserver2 is running, From Ambari -> Hive -> Conf check property value Unlike other data drivers for Hadoop/Hive, Simbas Apache Hive ODBC Driver with SQL Connector performs the added task of mapping advanced SQL functionality to HiveQL to provide users with. Ahmad Below steps will help you in setting up ODBC.ġ.