flink 1.11.2及1.12.0写读hive表无法读取数据问题

[﹏〆﹎゛ 独家记忆 <60...@qq.com>]

在flink 1.11.2和1.12.0都尝试通过flink table api 去读hive表数据，在flink client提交脚本后，可以看到表结构但是没有数据


代码：
        EnvironmentSettings settings = EnvironmentSettings.newInstance()
                .useBlinkPlanner()
                .inBatchMode()
                .build();
        TableEnvironment tableEnv = TableEnvironment.create(settings);


        String name = "hive";
        String defaultDatabase = "db";
        String hiveConfDir = "/etc/hive/conf/"; // a local path


        HiveCatalog hive = new HiveCatalog(name, defaultDatabase, hiveConfDir);
        tableEnv.registerCatalog("hive", hive);


        // set the HiveCatalog as the current catalog of the session
        tableEnv.useCatalog("hive");


        tableEnv.useDatabase("db");


        log.info("flink current catalog : {}", tableEnv.getCurrentCatalog());
        Table memberTable = tableEnv.sqlQuery("select * from `member` limit 10");
        memberTable.select($("id"), $("username")).execute().print();



flink client执行结果：
可以看到表结构，但是没有数据



Job has been submitted with JobID 36ba2b2f28e45d9dfcb287223748514a

+--------------------------------+--------------------------------+

|                             id |                       username |

+--------------------------------+--------------------------------+

还有一个问题：
TableEnironment批作业不提供类型sparkSession的close方法吗？只能等它自动退出吗？



org.apache.flink.client.program.ProgramInvocationException: The main method caused an error: Failed to fetch next result

	at org.apache.flink.client.program.PackagedProgram.callMainMethod(PackagedProgram.java:330)

	at org.apache.flink.client.program.PackagedProgram.invokeInteractiveModeForExecution(PackagedProgram.java:198)

	at org.apache.flink.client.ClientUtils.executeProgram(ClientUtils.java:114)

	at org.apache.flink.client.cli.CliFrontend.executeProgram(CliFrontend.java:743)

	at org.apache.flink.client.cli.CliFrontend.run(CliFrontend.java:242)

	at org.apache.flink.client.cli.CliFrontend.parseAndRun(CliFrontend.java:971)

	at org.apache.flink.client.cli.CliFrontend.lambda$main$10(CliFrontend.java:1047)

	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.contexts.HadoopSecurityContext.runSecured(HadoopSecurityContext.java:41)

	at org.apache.flink.client.cli.CliFrontend.main(CliFrontend.java:1047)

Caused by: java.lang.RuntimeException: Failed to fetch next result

	at org.apache.flink.streaming.api.operators.collect.CollectResultIterator.nextResultFromFetcher(CollectResultIterator.java:106)

	at org.apache.flink.streaming.api.operators.collect.CollectResultIterator.hasNext(CollectResultIterator.java:77)

	at org.apache.flink.table.planner.sinks.SelectTableSinkBase$RowIteratorWrapper.hasNext(SelectTableSinkBase.java:115)

	at org.apache.flink.table.api.internal.TableResultImpl$CloseableRowIteratorWrapper.hasNext(TableResultImpl.java:355)

	at org.apache.flink.table.utils.PrintUtils.printAsTableauForm(PrintUtils.java:155)

	at org.apache.flink.table.api.internal.TableResultImpl.print(TableResultImpl.java:149)

	at com.bestcem.dcp.flink.HiveFlinkJob.main(HiveFlinkJob.java:38)

	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

	at java.lang.reflect.Method.invoke(Method.java:498)

	at org.apache.flink.client.program.PackagedProgram.callMainMethod(PackagedProgram.java:316)

	... 11 more

Caused by: java.io.IOException: Failed to fetch job execution result

	at org.apache.flink.streaming.api.operators.collect.CollectResultFetcher.getAccumulatorResults(CollectResultFetcher.java:175)

	at org.apache.flink.streaming.api.operators.collect.CollectResultFetcher.next(CollectResultFetcher.java:126)

	at org.apache.flink.streaming.api.operators.collect.CollectResultIterator.nextResultFromFetcher(CollectResultIterator.java:103)

	... 22 more

Caused by: java.util.concurrent.TimeoutException

	at java.util.concurrent.CompletableFuture.timedGet(CompletableFuture.java:1771)

	at java.util.concurrent.CompletableFuture.get(CompletableFuture.java:1915)

	at org.apache.flink.streaming.api.operators.collect.CollectResultFetcher.getAccumulatorResults(CollectResultFetcher.java:172)

	... 24 more