Re: Cannot connect to hive

2019-06-21 Thread Valeriy Trofimov
Thanks all for the advice, but nothing works for me. If it works for you, do you use an official Spark build or your own custom build with possible bug fixes that make it work? I found this bug in Spark that could cause my issue: https://issues.apache.org/jira/browse/SPARK-9686. I'll let you know

Re: Cannot connect to hive

2019-06-19 Thread Zhu Feng
In our environment (Hive-2.2x), the following configuration works well. (jdbcCatalog=null, jdbcSchema=db_name) Therefore, maybe you need to add a line in your Shema's json .. jdbcSchema: 'thrift' . Best, DonnyZone Valeriy Trofimov

Re: Cannot connect to hive

2019-06-19 Thread Danny Chan
“thrift" is not even a schema, why do you use it here ? Maybe you should try “default" as schema name, and be caution that you should quote the “default” keyword because it’s a reserved word for Calcite. Best, Danny Chan 在 2019年6月19日 +0800 PM11:41,Valeriy Trofimov ,写道: > Hi Zhu, > > Setting it

Re: Cannot connect to hive

2019-06-19 Thread Valeriy Trofimov
Hi Zhu, Setting it to null shows "database null not found". My schema is missing jdbcCatalog entry. What value should I put there? I could not find anything in hive doc: https://cwiki.apache.org/confluence/display/Hive/HiveClient After playing with it more I've realized that it is able to

Re: Cannot connect to hive

2019-06-18 Thread Zhu Feng
Hi Valeriy, I remember that "jdbcCatalog" and "jdbcSchema" should be carefully configured for Hive Jdbc. Maybe you can try "null" or db name. best, DonnyZone Valeriy Trofimov 于2019年6月19日周三 上午8:11写道: > Hi All, > > I'm trying to connect to Hive DB via Thrift JDBC Server. > > I get error: "Object

Cannot connect to hive

2019-06-18 Thread Valeriy Trofimov
Hi All, I'm trying to connect to Hive DB via Thrift JDBC Server. I get error: "Object 'test' not found within 'thrift'". The error occurs by the IdentifierNamespace.resolveImpl() method. The method checks that schema looks correct based on my query. Schema: { version: '1.0', schemas: [