Re: Re: flink sql DDL Unsupported update-mode hbase
是的。 On Wed, 17 Jun 2020 at 13:50, Zhou Zach wrote: > 那flink sql DDL的方式,读写,更新,删除hbase都是支持的吧 > > > > > > > > > > > > > > > > > > At 2020-06-17 13:45:15, "Jark Wu" wrote: > >Hi, > > > >HBase connector 不用声明 update-mode 属性。 也不能声明。 > > > >Best, > >Jark > > > >On Wed, 17 Jun 2020 at 13:08, Zhou Zach wrote: > > > >> The program finished with the following exception: > >> > >> > >> org.apache.flink.client.program.ProgramInvocationException: The main > >> method caused an error: Could not find a suitable table factory for > >> 'org.apache.flink.table.factories.TableSinkFactory' in > >> the classpath. > >> > >> > >> Reason: No factory supports all properties. > >> > >> > >> The matching candidates: > >> org.apache.flink.addons.hbase.HBaseTableFactory > >> Unsupported property keys: > >> update-mode > >> > >> > >> The following properties are requested: > >> connector.table-name=user_hbase10 > >> connector.type=hbase > >> connector.version=2.1.0 > >> connector.write.buffer-flush.interval=2s > >> connector.write.buffer-flush.max-rows=1000 > >> connector.write.buffer-flush.max-size=10mb > >> connector.zookeeper.quorum=cdh1:2181,cdh2:2181,cdh3:2181 > >> connector.zookeeper.znode.parent=/hbase > >> schema.0.data-type=VARCHAR(2147483647) > >> schema.0.name=rowkey > >> schema.1.data-type=ROW<`sex` VARCHAR(2147483647), `age` INT, > >> `created_time` TIMESTAMP(3) > >> schema.1.name=cf > >> update-mode=upsert > >> > >> > >> The following factories have been considered: > >> org.apache.flink.addons.hbase.HBaseTableFactory > >> org.apache.flink.api.java.io.jdbc.JDBCTableSourceSinkFactory > >> org.apache.flink.streaming.connectors.kafka.KafkaTableSourceSinkFactory > >> org.apache.flink.table.sinks.CsvBatchTableSinkFactory > >> org.apache.flink.table.sinks.CsvAppendTableSinkFactory > >> at > >> > org.apache.flink.client.program.PackagedProgram.callMainMethod(PackagedProgram.java:335) > >> at > >> > org.apache.flink.client.program.PackagedProgram.invokeInteractiveModeForExecution(PackagedProgram.java:205) > >> at > >> org.apache.flink.client.ClientUtils.executeProgram(ClientUtils.java:138) > >> at > >> > org.apache.flink.client.cli.CliFrontend.executeProgram(CliFrontend.java:664) > >> at > >> org.apache.flink.client.cli.CliFrontend.run(CliFrontend.java:213) > >> at > >> > org.apache.flink.client.cli.CliFrontend.parseParameters(CliFrontend.java:895) > >> at > >> > org.apache.flink.client.cli.CliFrontend.lambda$main$10(CliFrontend.java:968) > >> at java.security.AccessController.doPrivileged(Native Method) > >> at javax.security.auth.Subject.doAs(Subject.java:422) > >> at > >> > org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1875) > >> at > >> > org.apache.flink.runtime.security.HadoopSecurityContext.runSecured(HadoopSecurityContext.java:41) > >> at > >> org.apache.flink.client.cli.CliFrontend.main(CliFrontend.java:968) > >> Caused by: org.apache.flink.table.api.NoMatchingTableFactoryException: > >> Could not find a suitable table factory for > >> 'org.apache.flink.table.factories.TableSinkFactory' in > >> the classpath. > >> > >> > >> Reason: No factory supports all properties. > >> > >> > >> The matching candidates: > >> org.apache.flink.addons.hbase.HBaseTableFactory > >> Unsupported property keys: > >> update-mode > >> > >> > >> The following properties are requested: > >> connector.table-name=user_hbase10 > >> connector.type=hbase > >> connector.version=2.1.0 > >> connector.write.buffer-flush.interval=2s > >> connector.write.buffer-flush.max-rows=1000 > >> connector.write.buffer-flush.max-size=10mb > >> connector.zookeeper.quorum=cdh1:2181,cdh2:2181,cdh3:2181 > >> connector.zookeeper.znode.parent=/hbase > >> schema.0.data-type=VARCHAR(2147483647) > >> schema.0.name=rowkey > >> schema.1.data-type=ROW<`sex` VARCHAR(2147483647), `age` INT, > >> `created_time` TIMESTAMP(3) > >> schema.1.name=cf > >> update-mode=upsert > >> > >> > >> The following factories have been considered: > >> org.apache.flink.addons.hbase.HBaseTableFactory > >> org.apache.flink.api.java.io.jdbc.JDBCTableSourceSinkFactory > >> org.apache.flink.streaming.connectors.kafka.KafkaTableSourceSinkFactory > >> org.apache.flink.table.sinks.CsvBatchTableSinkFactory > >> org.apache.flink.table.sinks.CsvAppendTableSinkFactory > >> at > >> > org.apache.flink.table.factories.TableFactoryService.filterBySupportedProperties(TableFactoryService.java:434) > >> at > >> > org.apache.flink.table.factories.TableFactoryService.filter(TableFactoryService.java:195) > >> at > >> > org.apache.flink.table.factories.TableFactoryService.findSingleInternal(TableFactoryService.java:143) > >> at > >> > org.apache.flink.table.factories.TableFactoryService.find(TableFactoryService.java:96) > >> at > >> > org.apache.flink.table.planner.delegation.PlannerBase.getTableSink(PlannerBase.scala:310) > >> at > >> >
Re: flink sql DDL Unsupported update-mode hbase
Hi, HBase connector 不用声明 update-mode 属性。 也不能声明。 Best, Jark On Wed, 17 Jun 2020 at 13:08, Zhou Zach wrote: > The program finished with the following exception: > > > org.apache.flink.client.program.ProgramInvocationException: The main > method caused an error: Could not find a suitable table factory for > 'org.apache.flink.table.factories.TableSinkFactory' in > the classpath. > > > Reason: No factory supports all properties. > > > The matching candidates: > org.apache.flink.addons.hbase.HBaseTableFactory > Unsupported property keys: > update-mode > > > The following properties are requested: > connector.table-name=user_hbase10 > connector.type=hbase > connector.version=2.1.0 > connector.write.buffer-flush.interval=2s > connector.write.buffer-flush.max-rows=1000 > connector.write.buffer-flush.max-size=10mb > connector.zookeeper.quorum=cdh1:2181,cdh2:2181,cdh3:2181 > connector.zookeeper.znode.parent=/hbase > schema.0.data-type=VARCHAR(2147483647) > schema.0.name=rowkey > schema.1.data-type=ROW<`sex` VARCHAR(2147483647), `age` INT, > `created_time` TIMESTAMP(3) > schema.1.name=cf > update-mode=upsert > > > The following factories have been considered: > org.apache.flink.addons.hbase.HBaseTableFactory > org.apache.flink.api.java.io.jdbc.JDBCTableSourceSinkFactory > org.apache.flink.streaming.connectors.kafka.KafkaTableSourceSinkFactory > org.apache.flink.table.sinks.CsvBatchTableSinkFactory > org.apache.flink.table.sinks.CsvAppendTableSinkFactory > at > org.apache.flink.client.program.PackagedProgram.callMainMethod(PackagedProgram.java:335) > at > org.apache.flink.client.program.PackagedProgram.invokeInteractiveModeForExecution(PackagedProgram.java:205) > at > org.apache.flink.client.ClientUtils.executeProgram(ClientUtils.java:138) > at > org.apache.flink.client.cli.CliFrontend.executeProgram(CliFrontend.java:664) > at > org.apache.flink.client.cli.CliFrontend.run(CliFrontend.java:213) > at > org.apache.flink.client.cli.CliFrontend.parseParameters(CliFrontend.java:895) > at > org.apache.flink.client.cli.CliFrontend.lambda$main$10(CliFrontend.java:968) > at java.security.AccessController.doPrivileged(Native Method) > at javax.security.auth.Subject.doAs(Subject.java:422) > at > org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1875) > at > org.apache.flink.runtime.security.HadoopSecurityContext.runSecured(HadoopSecurityContext.java:41) > at > org.apache.flink.client.cli.CliFrontend.main(CliFrontend.java:968) > Caused by: org.apache.flink.table.api.NoMatchingTableFactoryException: > Could not find a suitable table factory for > 'org.apache.flink.table.factories.TableSinkFactory' in > the classpath. > > > Reason: No factory supports all properties. > > > The matching candidates: > org.apache.flink.addons.hbase.HBaseTableFactory > Unsupported property keys: > update-mode > > > The following properties are requested: > connector.table-name=user_hbase10 > connector.type=hbase > connector.version=2.1.0 > connector.write.buffer-flush.interval=2s > connector.write.buffer-flush.max-rows=1000 > connector.write.buffer-flush.max-size=10mb > connector.zookeeper.quorum=cdh1:2181,cdh2:2181,cdh3:2181 > connector.zookeeper.znode.parent=/hbase > schema.0.data-type=VARCHAR(2147483647) > schema.0.name=rowkey > schema.1.data-type=ROW<`sex` VARCHAR(2147483647), `age` INT, > `created_time` TIMESTAMP(3) > schema.1.name=cf > update-mode=upsert > > > The following factories have been considered: > org.apache.flink.addons.hbase.HBaseTableFactory > org.apache.flink.api.java.io.jdbc.JDBCTableSourceSinkFactory > org.apache.flink.streaming.connectors.kafka.KafkaTableSourceSinkFactory > org.apache.flink.table.sinks.CsvBatchTableSinkFactory > org.apache.flink.table.sinks.CsvAppendTableSinkFactory > at > org.apache.flink.table.factories.TableFactoryService.filterBySupportedProperties(TableFactoryService.java:434) > at > org.apache.flink.table.factories.TableFactoryService.filter(TableFactoryService.java:195) > at > org.apache.flink.table.factories.TableFactoryService.findSingleInternal(TableFactoryService.java:143) > at > org.apache.flink.table.factories.TableFactoryService.find(TableFactoryService.java:96) > at > org.apache.flink.table.planner.delegation.PlannerBase.getTableSink(PlannerBase.scala:310) > at > org.apache.flink.table.planner.delegation.PlannerBase.translateToRel(PlannerBase.scala:190) > at > org.apache.flink.table.planner.delegation.PlannerBase$$anonfun$1.apply(PlannerBase.scala:150) > at > org.apache.flink.table.planner.delegation.PlannerBase$$anonfun$1.apply(PlannerBase.scala:150) > at > scala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234) > at > scala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234) > at