ODBC is the most common data interface used by BI, data analysis and reporting applications for relational data connectivity. Simba is the ODBC expert, and we chose its technology to enable access to the Hortonworks Data Platform because it offers our customers the broadest compatibility with SQL-based applications." "Simba''s Apache Hive ODBC Driver technology makes it easier for our customers to harness the power of their Big Data using popular and familiar BI and analytics applications. "Hortonworks makes Apache Hadoop easier to consume and use in enterprise environments," said Shaun Connolly, Hortonworks'' VP Strategy. Choosing Simba''s Apache Hive ODBC Driver with SQL Connector enables Hortonworks to give its customers easy access to their data for Business Intelligence (BI) and analytics using the SQL-based application of their choice. Let me know if it Ahmad Below steps will help you in setting up ODBC.VANCOUVER, BRITISH COLUMBIA-(Marketwire - Oct 11, 2012) - Simba Technologies, the industry''s Open Database Connectivity (ODBC) expert for Big Data solutions, announced today that it has partnered with Hortonworks, a leading commercial vendor of Apache Hadoop, to provide ODBC access to Hortonworks Data Platform. In case of LDAP pass username/password with auth as username and password. 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.Ģ. 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 Check on what Mode my Hiveserver2 is running, From Ambari -> Hive -> Conf check property value Ahmad Below steps will help you in setting up ODBC.ġ.
0 kommentar(er)
