[h2] Re: unable to create linked table on hive database/tables
Hello. H2 needs to know some information about the linked database to work with its tables. Each JDBC driver must implement these basic methods. You need to report your problem as an issue with Apache Hive it its bugtracker: https://issues.apache.org/jira/projects/HIVE/issues There is nothing to do with H2. You can use an own build of Hive with your own implementation of them or own build of H2 with hard-coded properties of Hive as a temporary workaround. -- 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 h2-database+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/a932d240-b99f-4b8b-b180-06a7ee6f6bb3%40googlegroups.com.
[h2] unable to create linked table on hive database/tables
Code: CREATE LINKED TABLE EMP_DATA3 ('org.apache.hive.jdbc.HiveDriver',
'jdbc:hive2://192.168.0.36:1/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:1/default;user=hive;password=hive' ,'hive',
'hive' , 'emp_data') [0-200]
null/0 (Help)
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:1/default;user=hive;password=hive' ,'hive',
'hive' , 'emp_data') [0-200]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:629
)
at org.h2.message.DbException.addSQL(DbException.java:159
)
at org.h2.command.Command.executeUpdate(Command.java:263
)
at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:228
)
at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:201
)
at org.h2.server.web.WebApp.getResult(WebApp.java:1459
)
at org.h2.server.web.WebApp.query(WebApp.java:1116
)
at org.h2.server.web.WebApp$1.next(WebApp.java:1078
)
at org.h2.server.web.WebApp$1.next(WebApp.java:1065
)
at org.h2.server.web.WebThread.process(WebThread.java:178
)
at org.h2.server.web.WebThread.run(WebThread.java:94
)
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
)
at org.h2.table.TableLink.connect(TableLink.java:99
)
at org.h2.table.TableLink.(TableLink.java:79
)
at org.h2.schema.Schema.createTableLink(Schema.java:736
)
at org.h2.command.ddl.CreateLinkedTable.update(CreateLinkedTable.java:77
)
at org.h2.command.CommandContainer.update(CommandContainer.java:198
)
at org.h2.command.Command.executeUpdate(Command.java:251
)
... 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 h2-database+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/h2-database/2c22467f-d688-4213-8634-ff9b9817bb3f%40googlegroups.com.
[h2] hive table cannot be linked
I tried to link a hive table to h2 but get a message Method not supported, this is because some method in hive drive is implemented with throw exception, is there a way to link hive table pls let me know. drivers are pointed correctly, able to connect postgress or ms sql but not hive -- 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 h2-database+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/670f5f67-7c78-40cc-b04a-c15c127c2ac3%40googlegroups.com.
Re: [h2] database benchmark performace mysql vs cache vs system vs directory file
Not really, look up how an LRU cache works e.g. https://en.wikipedia.org/wiki/Cache_replacement_policies -- 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 h2-database+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/CAFYHVnV3NRqE9HOWmzVFPPJAriyJg5MB%2BxgMauW%3DZnFmbyhvwQ%40mail.gmail.com.
Re: [h2] is there any clustering, replication and backup functionality?
No > -- 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 h2-database+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/CAFYHVnXKGAGeAJwjBivY9Q9i_H-yM%3DdK2O28UgqKLsb7TPviFw%40mail.gmail.com.
