Code: CREATE LINKED TABLE EMP_DATA3 ('org.apache.hive.jdbc.HiveDriver',
'jdbc:hive2://192.168.0.36:10000/default;user=hive;password=****' ,'hive',
'****' , 'emp_data');
Hive driver: hive-jdbc-uber-2.6.5.0-292.jar
*Error*
Method not supported; SQL statement:
CREATE LINKED TABLE EMP_DATA3('org.apache.hive.jdbc.HiveDriver',
'jdbc:hive2://192.168.0.36:10000/default;user=hive;password=hive' ,'hive',
'hive' , 'emp_data') [0-200]
<http://192.168.0.34:8082/query.do?jsessionid=dc9aadb5469937e4bcf977baaad94bb2#>
null/0 (Help) <https://h2database.com/javadoc/org/h2/api/ErrorCode.html#c0>
org.h2.jdbc.JdbcSQLException: Method not supported; SQL statement:
CREATE LINKED TABLE EMP_DATA3('org.apache.hive.jdbc.HiveDriver',
'jdbc:hive2://192.168.0.36:10000/default;user=hive;password=hive' ,'hive',
'hive' , 'emp_data') [0-200]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:629
<https://h2database.com/html/source.html?file=org/h2/message/DbException.java&line=629&build=200>
)
at org.h2.message.DbException.addSQL(DbException.java:159
<https://h2database.com/html/source.html?file=org/h2/message/DbException.java&line=159&build=200>
)
at org.h2.command.Command.executeUpdate(Command.java:263
<https://h2database.com/html/source.html?file=org/h2/command/Command.java&line=263&build=200>
)
at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:228
<https://h2database.com/html/source.html?file=org/h2/jdbc/JdbcStatement.java&line=228&build=200>
)
at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:201
<https://h2database.com/html/source.html?file=org/h2/jdbc/JdbcStatement.java&line=201&build=200>
)
at org.h2.server.web.WebApp.getResult(WebApp.java:1459
<https://h2database.com/html/source.html?file=org/h2/server/web/WebApp.java&line=1459&build=200>
)
at org.h2.server.web.WebApp.query(WebApp.java:1116
<https://h2database.com/html/source.html?file=org/h2/server/web/WebApp.java&line=1116&build=200>
)
at org.h2.server.web.WebApp$1.next(WebApp.java:1078
<https://h2database.com/html/source.html?file=org/h2/server/web/WebApp.java&line=1078&build=200>
)
at org.h2.server.web.WebApp$1.next(WebApp.java:1065
<https://h2database.com/html/source.html?file=org/h2/server/web/WebApp.java&line=1065&build=200>
)
at org.h2.server.web.WebThread.process(WebThread.java:178
<https://h2database.com/html/source.html?file=org/h2/server/web/WebThread.java&line=178&build=200>
)
at org.h2.server.web.WebThread.run(WebThread.java:94
<https://h2database.com/html/source.html?file=org/h2/server/web/WebThread.java&line=94&build=200>
)
at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: Method not supported
at
org.apache.hive.jdbc.HiveDatabaseMetaData.storesLowerCaseIdentifiers(HiveDatabaseMetaData.java:822)
at org.h2.table.TableLink.readMetaData(TableLink.java:119
<https://h2database.com/html/source.html?file=org/h2/table/TableLink.java&line=119&build=200>
)
at org.h2.table.TableLink.connect(TableLink.java:99
<https://h2database.com/html/source.html?file=org/h2/table/TableLink.java&line=99&build=200>
)
at org.h2.table.TableLink.<init>(TableLink.java:79
<https://h2database.com/html/source.html?file=org/h2/table/TableLink.java&line=79&build=200>
)
at org.h2.schema.Schema.createTableLink(Schema.java:736
<https://h2database.com/html/source.html?file=org/h2/schema/Schema.java&line=736&build=200>
)
at org.h2.command.ddl.CreateLinkedTable.update(CreateLinkedTable.java:77
<https://h2database.com/html/source.html?file=org/h2/command/ddl/CreateLinkedTable.java&line=77&build=200>
)
at org.h2.command.CommandContainer.update(CommandContainer.java:198
<https://h2database.com/html/source.html?file=org/h2/command/CommandContainer.java&line=198&build=200>
)
at org.h2.command.Command.executeUpdate(Command.java:251
<https://h2database.com/html/source.html?file=org/h2/command/Command.java&line=251&build=200>
)
... 9 more
checked in hive driver looks like storesLowerCaseIdentifiers are set set to
throw exception is there a way around to link tables from hive?
pls help.
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/h2-database/2c22467f-d688-4213-8634-ff9b9817bb3f%40googlegroups.com.
