flink 1.11.1 使用sql ,使用hbase作为维表进行temporal join时无法获取数据

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

flink 1.11.1 使用sql ,使用hbase作为维表进行temporal join时无法获取数据

鱼子酱
Hi,社区的各位大家好:
我在使用Hbase作为维表,进行temporal join时无法获取数据,
具体表现就是任务可以运行,但是没有符合条件的数据输出。
flink版本是1.11.1,Hbase版本是1.2.0-cdh5.15.1

1、我测试了,如果去掉关联条件只读取kafka源:
    insert into testhbase
        select cast(applog.terminalNo as varchar)
        from applog
,是能够输出数据,

但是一旦加上关联条件,就无法输出了。

2、请问目前hbase支持使用sql进行scan或者查询吗?我目前想要尝试只把Hbase的数据scan出来检查一下,但是使用下面这个sql的话,任务会自动停止,
  select.sql1: >
    insert into testhbase
        select rowkey
        from  shop
报错如下:
14:25:51,726 INFO
org.apache.flink.runtime.taskexecutor.TaskExecutorResourceUtils  - The
configuration option taskmanager.cpu.cores required for local execution is
not set, setting it to the maximal possible value.
14:25:51,727 INFO
org.apache.flink.runtime.taskexecutor.TaskExecutorResourceUtils  - The
configuration option taskmanager.memory.task.heap.size required for local
execution is not set, setting it to the maximal possible value.
14:25:51,727 INFO
org.apache.flink.runtime.taskexecutor.TaskExecutorResourceUtils  - The
configuration option taskmanager.memory.task.off-heap.size required for
local execution is not set, setting it to the maximal possible value.
14:25:51,728 INFO
org.apache.flink.runtime.taskexecutor.TaskExecutorResourceUtils  - The
configuration option taskmanager.memory.network.min required for local
execution is not set, setting it to its default value 64 mb.
14:25:51,728 INFO
org.apache.flink.runtime.taskexecutor.TaskExecutorResourceUtils  - The
configuration option taskmanager.memory.network.max required for local
execution is not set, setting it to its default value 64 mb.
14:25:51,728 INFO
org.apache.flink.runtime.taskexecutor.TaskExecutorResourceUtils  - The
configuration option taskmanager.memory.managed.size required for local
execution is not set, setting it to its default value 128 mb.
14:25:51,733 INFO  org.apache.flink.runtime.minicluster.MiniCluster            
- Starting Flink Mini Cluster
14:25:51,734 INFO  org.apache.flink.runtime.minicluster.MiniCluster            
- Starting Metrics Registry
14:25:51,764 INFO  org.apache.flink.runtime.metrics.MetricRegistryImpl          
- No metrics reporter configured, no metrics will be exposed/reported.
14:25:51,764 INFO  org.apache.flink.runtime.minicluster.MiniCluster            
- Starting RPC Service(s)
14:25:51,772 INFO  org.apache.flink.runtime.rpc.akka.AkkaRpcServiceUtils        
- Trying to start local actor system
14:25:51,998 INFO  akka.event.slf4j.Slf4jLogger                                
- Slf4jLogger started
14:25:52,155 INFO  org.apache.flink.runtime.rpc.akka.AkkaRpcServiceUtils        
- Actor system started at akka://flink
14:25:52,163 INFO  org.apache.flink.runtime.rpc.akka.AkkaRpcServiceUtils        
- Trying to start local actor system
14:25:52,174 INFO  akka.event.slf4j.Slf4jLogger                                
- Slf4jLogger started
14:25:52,196 INFO  org.apache.flink.runtime.rpc.akka.AkkaRpcServiceUtils        
- Actor system started at akka://flink-metrics
14:25:52,205 INFO  org.apache.flink.runtime.rpc.akka.AkkaRpcService            
- Starting RPC endpoint for
org.apache.flink.runtime.metrics.dump.MetricQueryService at
akka://flink-metrics/user/rpc/MetricQueryService .
14:25:52,248 INFO  org.apache.flink.runtime.minicluster.MiniCluster            
- Starting high-availability services
14:25:52,339 INFO  org.apache.flink.runtime.blob.BlobServer                    
- Created BLOB server storage directory
C:\Users\xufuquan\AppData\Local\Temp\blobStore-15963e40-62fd-41f6-b79e-34478d9076f5
14:25:52,344 INFO  org.apache.flink.runtime.blob.BlobServer                    
- Started BLOB server at 0.0.0.0:51813 - max concurrent requests: 50 - max
backlog: 1000
14:25:52,352 INFO  org.apache.flink.runtime.blob.PermanentBlobCache            
- Created BLOB cache storage directory
C:\Users\xufuquan\AppData\Local\Temp\blobStore-b10a2d3a-c85d-4bc6-bb87-8ad33d264303
14:25:52,354 INFO  org.apache.flink.runtime.blob.TransientBlobCache            
- Created BLOB cache storage directory
C:\Users\xufuquan\AppData\Local\Temp\blobStore-61dffed1-c680-4279-8722-4d790dbfee34
14:25:52,354 INFO  org.apache.flink.runtime.minicluster.MiniCluster            
- Starting 1 TaskManger(s)
14:25:52,356 INFO  org.apache.flink.runtime.taskexecutor.TaskManagerRunner      
- Starting TaskManager with ResourceID: d0b1f67e-e303-4363-ad1c-24bd80702892
14:25:52,369 INFO  org.apache.flink.runtime.taskexecutor.TaskManagerServices    
- Temporary file directory 'C:\Users\xufuquan\AppData\Local\Temp': total 79
GB, usable 6 GB (7.59% usable)
14:25:52,371 INFO  org.apache.flink.runtime.io.disk.FileChannelManagerImpl      
- FileChannelManager uses directory
C:\Users\xufuquan\AppData\Local\Temp\flink-io-b354fbd8-8742-4f42-a615-645acc877dd1
for spill files.
14:25:52,376 INFO  org.apache.flink.runtime.io.disk.FileChannelManagerImpl      
- FileChannelManager uses directory
C:\Users\xufuquan\AppData\Local\Temp\flink-netty-shuffle-9bb16fd0-4b97-43ce-b055-5dac35a91e71
for spill files.
14:25:52,404 INFO
org.apache.flink.runtime.io.network.buffer.NetworkBufferPool  - Allocated 64
MB for network buffer pool (number of memory segments: 2048, bytes per
segment: 32768).
14:25:52,408 INFO
org.apache.flink.runtime.io.network.NettyShuffleEnvironment   - Starting the
network environment and its components.
14:25:52,409 INFO  org.apache.flink.runtime.taskexecutor.KvStateService        
- Starting the kvState service and its components.
14:25:52,423 INFO  org.apache.flink.runtime.rpc.akka.AkkaRpcService            
- Starting RPC endpoint for
org.apache.flink.runtime.taskexecutor.TaskExecutor at
akka://flink/user/rpc/taskmanager_0 .
14:25:52,432 INFO
org.apache.flink.runtime.taskexecutor.DefaultJobLeaderService  - Start job
leader service.
14:25:52,434 INFO  org.apache.flink.runtime.filecache.FileCache                
- User file cache uses directory
C:\Users\xufuquan\AppData\Local\Temp\flink-dist-cache-85fde370-d9f9-425a-a021-fabcaceeddce
14:25:52,463 INFO
org.apache.flink.runtime.dispatcher.DispatcherRestEndpoint    - Starting
rest endpoint.
14:25:52,465 INFO
org.apache.flink.runtime.dispatcher.DispatcherRestEndpoint    - Failed to
load web based job submission extension. Probable reason: flink-runtime-web
is not in the classpath.
14:25:52,525 WARN  org.apache.flink.runtime.webmonitor.WebMonitorUtils          
- Log file environment variable 'log.file' is not set.
14:25:52,525 WARN  org.apache.flink.runtime.webmonitor.WebMonitorUtils          
- JobManager log files are unavailable in the web dashboard. Log file
location not found in environment variable 'log.file' or configuration key
'web.log.path'.
14:25:52,738 INFO
org.apache.flink.runtime.dispatcher.DispatcherRestEndpoint    - Rest
endpoint listening at localhost:51848
14:25:52,739 INFO
org.apache.flink.runtime.highavailability.nonha.embedded.EmbeddedLeaderService
- Proposing leadership to contender http://localhost:51848
14:25:52,742 INFO
org.apache.flink.runtime.dispatcher.DispatcherRestEndpoint    -
http://localhost:51848 was granted leadership with
leaderSessionID=817edd39-38ee-4080-aafd-f41a122f6e5b
14:25:52,742 INFO
org.apache.flink.runtime.highavailability.nonha.embedded.EmbeddedLeaderService
- Received confirmation of leadership for leader http://localhost:51848 ,
session=817edd39-38ee-4080-aafd-f41a122f6e5b
14:25:52,750 INFO  org.apache.flink.runtime.rpc.akka.AkkaRpcService            
- Starting RPC endpoint for
org.apache.flink.runtime.resourcemanager.StandaloneResourceManager at
akka://flink/user/rpc/resourcemanager_1 .
14:25:52,760 INFO
org.apache.flink.runtime.highavailability.nonha.embedded.EmbeddedLeaderService
- Proposing leadership to contender LeaderContender: DefaultDispatcherRunner
14:25:52,760 INFO
org.apache.flink.runtime.highavailability.nonha.embedded.EmbeddedLeaderService
- Proposing leadership to contender LeaderContender:
StandaloneResourceManager
14:25:52,762 INFO
org.apache.flink.runtime.resourcemanager.StandaloneResourceManager  -
ResourceManager akka://flink/user/rpc/resourcemanager_1 was granted
leadership with fencing token 98684bd1719147132d948067282c4f91
14:25:52,762 INFO  org.apache.flink.runtime.minicluster.MiniCluster            
- Flink Mini Cluster started successfully
14:25:52,763 INFO
org.apache.flink.runtime.resourcemanager.slotmanager.SlotManagerImpl  -
Starting the SlotManager.
14:25:52,764 INFO
org.apache.flink.runtime.dispatcher.runner.SessionDispatcherLeaderProcess  -
Start SessionDispatcherLeaderProcess.
14:25:52,766 INFO
org.apache.flink.runtime.dispatcher.runner.SessionDispatcherLeaderProcess  -
Recover all persisted job graphs.
14:25:52,766 INFO
org.apache.flink.runtime.dispatcher.runner.SessionDispatcherLeaderProcess  -
Successfully recovered 0 persisted job graphs.
14:25:52,766 INFO
org.apache.flink.runtime.highavailability.nonha.embedded.EmbeddedLeaderService
- Received confirmation of leadership for leader
akka://flink/user/rpc/resourcemanager_1 ,
session=2d948067-282c-4f91-9868-4bd171914713
14:25:52,767 INFO  org.apache.flink.runtime.taskexecutor.TaskExecutor          
- Connecting to ResourceManager
akka://flink/user/rpc/resourcemanager_1(98684bd1719147132d948067282c4f91).
14:25:52,771 INFO  org.apache.flink.runtime.rpc.akka.AkkaRpcService            
- Starting RPC endpoint for
org.apache.flink.runtime.dispatcher.StandaloneDispatcher at
akka://flink/user/rpc/dispatcher_2 .
14:25:52,780 INFO
org.apache.flink.runtime.highavailability.nonha.embedded.EmbeddedLeaderService
- Received confirmation of leadership for leader
akka://flink/user/rpc/dispatcher_2 ,
session=516e5ea3-b1c5-4f5a-8ceb-2dcffa53165a
14:25:52,782 INFO  org.apache.flink.runtime.taskexecutor.TaskExecutor          
- Resolved ResourceManager address, beginning registration
14:25:52,789 INFO
org.apache.flink.runtime.resourcemanager.StandaloneResourceManager  -
Registering TaskManager with ResourceID d0b1f67e-e303-4363-ad1c-24bd80702892
(akka://flink/user/rpc/taskmanager_0) at ResourceManager
14:25:52,790 INFO  org.apache.flink.runtime.dispatcher.StandaloneDispatcher    
- Received JobGraph submission 55d431a61265c7a2ecb0a24b5cdc7f71
(insert-into_default_catalog.default_database.testhbase).
14:25:52,790 INFO  org.apache.flink.runtime.dispatcher.StandaloneDispatcher    
- Submitting job 55d431a61265c7a2ecb0a24b5cdc7f71
(insert-into_default_catalog.default_database.testhbase).
14:25:52,790 INFO  org.apache.flink.runtime.taskexecutor.TaskExecutor          
- Successful registration at resource manager
akka://flink/user/rpc/resourcemanager_1 under registration id
3e4e764b990571645d2cddae0a8cc151.
14:25:52,806 INFO  org.apache.flink.runtime.rpc.akka.AkkaRpcService            
- Starting RPC endpoint for org.apache.flink.runtime.jobmaster.JobMaster at
akka://flink/user/rpc/jobmanager_3 .
14:25:52,811 INFO  org.apache.flink.runtime.jobmaster.JobMaster                
- Initializing job insert-into_default_catalog.default_database.testhbase
(55d431a61265c7a2ecb0a24b5cdc7f71).
14:25:52,823 INFO  org.apache.flink.runtime.jobmaster.JobMaster                
- Using restart back off time strategy NoRestartBackoffTimeStrategy for
insert-into_default_catalog.default_database.testhbase
(55d431a61265c7a2ecb0a24b5cdc7f71).
14:25:52,847 INFO  org.apache.flink.runtime.jobmaster.JobMaster                
- Running initialization on master for job
insert-into_default_catalog.default_database.testhbase
(55d431a61265c7a2ecb0a24b5cdc7f71).
14:25:52,848 INFO
org.apache.flink.connector.hbase.source.HBaseRowDataInputFormat  -
Initializing HBase configuration.
14:25:52,900 WARN  org.apache.hadoop.util.NativeCodeLoader                      
- Unable to load native-hadoop library for your platform... using
builtin-java classes where applicable
14:25:53,144 INFO  org.apache.hadoop.hbase.zookeeper.RecoverableZooKeeper      
- Process identifier=hconnection-0x321b92da connecting to ZooKeeper
ensemble=172.26.100.203:2181,172.26.100.204:2181,172.26.100.205:2181
14:25:53,147 INFO  org.apache.zookeeper.ZooKeeper                              
- Client
environment:zookeeper.version=3.4.10-39d3a4f269333c922ed3db283be479f9deacaa0f,
built on 03/23/2017 10:13 GMT
14:25:53,147 INFO  org.apache.zookeeper.ZooKeeper                              
- Client environment:host.name=xu-fuquan.cslc.com.cn
14:25:53,147 INFO  org.apache.zookeeper.ZooKeeper                              
- Client environment:java.version=1.8.0_191
14:25:53,147 INFO  org.apache.zookeeper.ZooKeeper                              
- Client environment:java.vendor=Oracle Corporation
14:25:53,147 INFO  org.apache.zookeeper.ZooKeeper                              
- Client environment:java.home=C:\Program Files\Java\jdk1.8.0_191\jre
14:25:53,147 INFO  org.apache.zookeeper.ZooKeeper                              
- Client environment:java.class.path=C:\Program
Files\Java\jdk1.8.0_191\jre\lib\charsets.jar;C:\Program
Files\Java\jdk1.8.0_191\jre\lib\deploy.jar;C:\Program
Files\Java\jdk1.8.0_191\jre\lib\ext\access-bridge-64.jar;C:\Program
Files\Java\jdk1.8.0_191\jre\lib\ext\cldrdata.jar;C:\Program
Files\Java\jdk1.8.0_191\jre\lib\ext\dnsns.jar;C:\Program
Files\Java\jdk1.8.0_191\jre\lib\ext\jaccess.jar;C:\Program
Files\Java\jdk1.8.0_191\jre\lib\ext\jfxrt.jar;C:\Program
Files\Java\jdk1.8.0_191\jre\lib\ext\localedata.jar;C:\Program
Files\Java\jdk1.8.0_191\jre\lib\ext\nashorn.jar;C:\Program
Files\Java\jdk1.8.0_191\jre\lib\ext\sunec.jar;C:\Program
Files\Java\jdk1.8.0_191\jre\lib\ext\sunjce_provider.jar;C:\Program
Files\Java\jdk1.8.0_191\jre\lib\ext\sunmscapi.jar;C:\Program
Files\Java\jdk1.8.0_191\jre\lib\ext\sunpkcs11.jar;C:\Program
Files\Java\jdk1.8.0_191\jre\lib\ext\zipfs.jar;C:\Program
Files\Java\jdk1.8.0_191\jre\lib\javaws.jar;C:\Program
Files\Java\jdk1.8.0_191\jre\lib\jce.jar;C:\Program
Files\Java\jdk1.8.0_191\jre\lib\jfr.jar;C:\Program
Files\Java\jdk1.8.0_191\jre\lib\jfxswt.jar;C:\Program
Files\Java\jdk1.8.0_191\jre\lib\jsse.jar;C:\Program
Files\Java\jdk1.8.0_191\jre\lib\management-agent.jar;C:\Program
Files\Java\jdk1.8.0_191\jre\lib\plugin.jar;C:\Program
Files\Java\jdk1.8.0_191\jre\lib\resources.jar;C:\Program
Files\Java\jdk1.8.0_191\jre\lib\rt.jar;F:\Workspaces\IDEA2018\log-analyse\target\classes;E:\maven-repository\repository\org\apache\flink\flink-java\1.11.2\flink-java-1.11.2.jar;E:\maven-repository\repository\org\apache\commons\commons-lang3\3.3.2\commons-lang3-3.3.2.jar;E:\maven-repository\repository\org\apache\commons\commons-math3\3.5\commons-math3-3.5.jar;E:\maven-repository\repository\org\slf4j\slf4j-api\1.7.15\slf4j-api-1.7.15.jar;E:\maven-repository\repository\com\google\code\findbugs\jsr305\1.3.9\jsr305-1.3.9.jar;E:\maven-repository\repository\org\apache\flink\force-shading\1.11.2\force-shading-1.11.2.jar;E:\maven-repository\repository\org\apache\flink\flink-streaming-java_2.11\1.11.2\flink-streaming-java_2.11-1.11.2.jar;E:\maven-repository\repository\org\apache\flink\flink-runtime_2.11\1.11.2\flink-runtime_2.11-1.11.2.jar;E:\maven-repository\repository\org\apache\flink\flink-queryable-state-client-java\1.11.2\flink-queryable-state-client-java-1.11.2.jar;E:\maven-repository\repository\org\apache\flink\flink-hadoop-fs\1.11.2\flink-hadoop-fs-1.11.2.jar;E:\maven-repository\repository\commons-io\commons-io\2.4\commons-io-2.4.jar;E:\maven-repository\repository\org\apache\flink\flink-shaded-netty\4.1.39.Final-11.0\flink-shaded-netty-4.1.39.Final-11.0.jar;E:\maven-repository\repository\org\apache\flink\flink-shaded-jackson\2.10.1-11.0\flink-shaded-jackson-2.10.1-11.0.jar;E:\maven-repository\repository\org\apache\flink\flink-shaded-zookeeper-3\3.4.14-11.0\flink-shaded-zookeeper-3-3.4.14-11.0.jar;E:\maven-repository\repository\org\javassist\javassist\3.24.0-GA\javassist-3.24.0-GA.jar;E:\maven-repository\repository\com\typesafe\akka\akka-actor_2.11\2.5.21\akka-actor_2.11-2.5.21.jar;E:\maven-repository\repository\com\typesafe\config\1.3.3\config-1.3.3.jar;E:\maven-repository\repository\org\scala-lang\modules\scala-java8-compat_2.11\0.7.0\scala-java8-compat_2.11-0.7.0.jar;E:\maven-repository\repository\com\typesafe\akka\akka-stream_2.11\2.5.21\akka-stream_2.11-2.5.21.jar;E:\maven-repository\repository\org\reactivestreams\reactive-streams\1.0.2\reactive-streams-1.0.2.jar;E:\maven-repository\repository\com\typesafe\ssl-config-core_2.11\0.3.7\ssl-config-core_2.11-0.3.7.jar;E:\maven-repository\repository\com\typesafe\akka\akka-protobuf_2.11\2.5.21\akka-protobuf_2.11-2.5.21.jar;E:\maven-repository\repository\com\typesafe\akka\akka-slf4j_2.11\2.5.21\akka-slf4j_2.11-2.5.21.jar;E:\maven-repository\repository\org\clapper\grizzled-slf4j_2.11\1.3.2\grizzled-slf4j_2.11-1.3.2.jar;E:\maven-repository\repository\com\github\scopt\scopt_2.11\3.5.0\scopt_2.11-3.5.0.jar;E:\maven-repository\repository\org\xerial\snappy\snappy-java\1.1.4\snappy-java-1.1.4.jar;E:\maven-repository\repository\com\twitter\chill_2.11\0.7.6\chill_2.11-0.7.6.jar;E:\maven-repository\repository\com\twitter\chill-java\0.7.6\chill-java-0.7.6.jar;E:\maven-repository\repository\org\lz4\lz4-java\1.6.0\lz4-java-1.6.0.jar;E:\maven-repository\repository\org\apache\flink\flink-shaded-guava\18.0-11.0\flink-shaded-guava-18.0-11.0.jar;E:\maven-repository\repository\org\apache\flink\flink-streaming-scala_2.11\1.11.2\flink-streaming-scala_2.11-1.11.2.jar;E:\maven-repository\repository\org\apache\flink\flink-scala_2.11\1.11.2\flink-scala_2.11-1.11.2.jar;E:\maven-repository\repository\org\scala-lang\scala-reflect\2.11.12\scala-reflect-2.11.12.jar;E:\maven-repository\repository\org\scala-lang\scala-library\2.11.12\scala-library-2.11.12.jar;E:\maven-repository\repository\org\scala-lang\scala-compiler\2.11.12\scala-compiler-2.11.12.jar;E:\maven-repository\repository\org\scala-lang\modules\scala-xml_2.11\1.0.5\scala-xml_2.11-1.0.5.jar;E:\maven-repository\repository\org\scala-lang\modules\scala-parser-combinators_2.11\1.0.4\scala-parser-combinators_2.11-1.0.4.jar;E:\maven-repository\repository\org\apache\flink\flink-core\1.11.2\flink-core-1.11.2.jar;E:\maven-repository\repository\org\apache\flink\flink-annotations\1.11.2\flink-annotations-1.11.2.jar;E:\maven-repository\repository\org\apache\flink\flink-metrics-core\1.11.2\flink-metrics-core-1.11.2.jar;E:\maven-repository\repository\org\apache\flink\flink-shaded-asm-7\7.1-11.0\flink-shaded-asm-7-7.1-11.0.jar;E:\maven-repository\repository\com\esotericsoftware\kryo\kryo\2.24.0\kryo-2.24.0.jar;E:\maven-repository\repository\com\esotericsoftware\minlog\minlog\1.2\minlog-1.2.jar;E:\maven-repository\repository\org\objenesis\objenesis\2.1\objenesis-2.1.jar;E:\maven-repository\repository\commons-collections\commons-collections\3.2.2\commons-collections-3.2.2.jar;E:\maven-repository\repository\org\apache\commons\commons-compress\1.20\commons-compress-1.20.jar;E:\maven-repository\repository\org\apache\flink\flink-clients_2.11\1.11.2\flink-clients_2.11-1.11.2.jar;E:\maven-repository\repository\org\apache\flink\flink-optimizer_2.11\1.11.2\flink-optimizer_2.11-1.11.2.jar;E:\maven-repository\repository\commons-cli\commons-cli\1.3.1\commons-cli-1.3.1.jar;E:\maven-repository\repository\org\apache\flink\flink-connector-kafka-0.10_2.11\1.11.2\flink-connector-kafka-0.10_2.11-1.11.2.jar;E:\maven-repository\repository\org\apache\flink\flink-connector-kafka-base_2.11\1.11.2\flink-connector-kafka-base_2.11-1.11.2.jar;E:\maven-repository\repository\org\apache\kafka\kafka-clients\0.10.2.2\kafka-clients-0.10.2.2.jar;E:\maven-repository\repository\net\jpountz\lz4\lz4\1.3.0\lz4-1.3.0.jar;E:\maven-repository\repository\org\apache\flink\flink-connector-jdbc_2.11\1.11.2\flink-connector-jdbc_2.11-1.11.2.jar;E:\maven-repository\repository\org\apache\flink\flink-table-api-java-bridge_2.11\1.11.2\flink-table-api-java-bridge_2.11-1.11.2.jar;E:\maven-repository\repository\org\apache\flink\flink-table-api-java\1.11.2\flink-table-api-java-1.11.2.jar;E:\maven-repository\repository\org\apache\flink\flink-table-common\1.11.2\flink-table-common-1.11.2.jar;E:\maven-repository\repository\org\apache\flink\flink-json\1.11.2\flink-json-1.11.2.jar;E:\maven-repository\repository\mysql\mysql-connector-java\8.0.17\mysql-connector-java-8.0.17.jar;E:\maven-repository\repository\com\google\protobuf\protobuf-java\3.6.1\protobuf-java-3.6.1.jar;E:\maven-repository\repository\org\slf4j\slf4j-log4j12\1.7.7\slf4j-log4j12-1.7.7.jar;E:\maven-repository\repository\log4j\log4j\1.2.17\log4j-1.2.17.jar;E:\maven-repository\repository\com\alibaba\fastjson\1.2.70\fastjson-1.2.70.jar;E:\maven-repository\repository\org\apache\flink\flink-table-planner-blink_2.11\1.11.2\flink-table-planner-blink_2.11-1.11.2.jar;E:\maven-repository\repository\org\apache\flink\flink-table-api-scala_2.11\1.11.2\flink-table-api-scala_2.11-1.11.2.jar;E:\maven-repository\repository\org\apache\flink\flink-table-api-scala-bridge_2.11\1.11.2\flink-table-api-scala-bridge_2.11-1.11.2.jar;E:\maven-repository\repository\org\apache\flink\flink-table-runtime-blink_2.11\1.11.2\flink-table-runtime-blink_2.11-1.11.2.jar;E:\maven-repository\repository\org\codehaus\janino\janino\3.0.9\janino-3.0.9.jar;E:\maven-repository\repository\org\codehaus\janino\commons-compiler\3.0.9\commons-compiler-3.0.9.jar;E:\maven-repository\repository\org\apache\calcite\avatica\avatica-core\1.16.0\avatica-core-1.16.0.jar;E:\maven-repository\repository\org\reflections\reflections\0.9.10\reflections-0.9.10.jar;E:\maven-repository\repository\org\apache\flink\flink-statebackend-rocksdb_2.11\1.11.2\flink-statebackend-rocksdb_2.11-1.11.2.jar;E:\maven-repository\repository\com\data-artisans\frocksdbjni\5.17.2-artisans-2.0\frocksdbjni-5.17.2-artisans-2.0.jar;E:\maven-repository\repository\org\apache\flink\flink-connector-hbase_2.11\1.11.2\flink-connector-hbase_2.11-1.11.2.jar;E:\maven-repository\repository\org\apache\hbase\hbase-server\1.4.3\hbase-server-1.4.3.jar;E:\maven-repository\repository\org\apache\hbase\hbase-common\1.4.3\hbase-common-1.4.3.jar;E:\maven-repository\repository\org\apache\avro\avro\1.7.7\avro-1.7.7.jar;E:\maven-repository\repository\com\thoughtworks\paranamer\paranamer\2.3\paranamer-2.3.jar;E:\maven-repository\repository\com\github\stephenc\findbugs\findbugs-annotations\1.3.9-1\findbugs-annotations-1.3.9-1.jar;E:\maven-repository\repository\org\apache\hbase\hbase-protocol\1.4.3\hbase-protocol-1.4.3.jar;E:\maven-repository\repository\org\apache\hbase\hbase-procedure\1.4.3\hbase-procedure-1.4.3.jar;E:\maven-repository\repository\org\apache\hbase\hbase-common\1.4.3\hbase-common-1.4.3-tests.jar;E:\maven-repository\repository\org\apache\hbase\hbase-client\1.4.3\hbase-client-1.4.3.jar;E:\maven-repository\repository\org\apache\hbase\hbase-prefix-tree\1.4.3\hbase-prefix-tree-1.4.3.jar;E:\maven-repository\repository\org\apache\hbase\hbase-metrics-api\1.4.3\hbase-metrics-api-1.4.3.jar;E:\maven-repository\repository\org\apache\hbase\hbase-metrics\1.4.3\hbase-metrics-1.4.3.jar;E:\maven-repository\repository\io\dropwizard\metrics\metrics-core\3.1.2\metrics-core-3.1.2.jar;E:\maven-repository\repository\commons-httpclient\commons-httpclient\3.1\commons-httpclient-3.1.jar;E:\maven-repository\repository\commons-codec\commons-codec\1.9\commons-codec-1.9.jar;E:\maven-repository\repository\org\apache\hbase\hbase-hadoop-compat\1.4.3\hbase-hadoop-compat-1.4.3.jar;E:\maven-repository\repository\org\apache\hbase\hbase-hadoop2-compat\1.4.3\hbase-hadoop2-compat-1.4.3.jar;E:\maven-repository\repository\com\yammer\metrics\metrics-core\2.2.0\metrics-core-2.2.0.jar;E:\maven-repository\repository\com\google\guava\guava\12.0.1\guava-12.0.1.jar;E:\maven-repository\repository\commons-lang\commons-lang\2.6\commons-lang-2.6.jar;E:\maven-repository\repository\commons-logging\commons-logging\1.2\commons-logging-1.2.jar;E:\maven-repository\repository\org\apache\commons\commons-math\2.2\commons-math-2.2.jar;E:\maven-repository\repository\org\apache\zookeeper\zookeeper\3.4.10\zookeeper-3.4.10.jar;E:\maven-repository\repository\org\codehaus\jackson\jackson-core-asl\1.9.13\jackson-core-asl-1.9.13.jar;E:\maven-repository\repository\org\codehaus\jackson\jackson-mapper-asl\1.9.13\jackson-mapper-asl-1.9.13.jar;E:\maven-repository\repository\org\codehaus\jackson\jackson-jaxrs\1.9.13\jackson-jaxrs-1.9.13.jar;E:\maven-repository\repository\org\apache\htrace\htrace-core\3.1.0-incubating\htrace-core-3.1.0-incubating.jar;E:\maven-repository\repository\com\lmax\disruptor\3.3.0\disruptor-3.3.0.jar;E:\maven-repository\repository\org\apache\httpcomponents\httpclient\4.5.2\httpclient-4.5.2.jar;E:\maven-repository\repository\org\apache\httpcomponents\httpcore\4.4.4\httpcore-4.4.4.jar;E:\maven-repository\repository\org\apache\hadoop\hadoop-common\2.7.4\hadoop-common-2.7.4.jar;E:\maven-repository\repository\org\apache\hadoop\hadoop-annotations\2.7.4\hadoop-annotations-2.7.4.jar;C:\Program
Files\Java\jdk1.8.0_191\lib\tools.jar;E:\maven-repository\repository\xmlenc\xmlenc\0.52\xmlenc-0.52.jar;E:\maven-repository\repository\commons-net\commons-net\3.1\commons-net-3.1.jar;E:\maven-repository\repository\com\sun\jersey\jersey-json\1.9\jersey-json-1.9.jar;E:\maven-repository\repository\org\codehaus\jettison\jettison\1.1\jettison-1.1.jar;E:\maven-repository\repository\com\sun\xml\bind\jaxb-impl\2.2.3-1\jaxb-impl-2.2.3-1.jar;E:\maven-repository\repository\org\codehaus\jackson\jackson-xc\1.8.3\jackson-xc-1.8.3.jar;E:\maven-repository\repository\net\java\dev\jets3t\jets3t\0.9.0\jets3t-0.9.0.jar;E:\maven-repository\repository\com\jamesmurty\utils\java-xmlbuilder\0.4\java-xmlbuilder-0.4.jar;E:\maven-repository\repository\commons-configuration\commons-configuration\1.6\commons-configuration-1.6.jar;E:\maven-repository\repository\commons-digester\commons-digester\1.8\commons-digester-1.8.jar;E:\maven-repository\repository\commons-beanutils\commons-beanutils\1.7.0\commons-beanutils-1.7.0.jar;E:\maven-repository\repository\commons-beanutils\commons-beanutils-core\1.8.0\commons-beanutils-core-1.8.0.jar;E:\maven-repository\repository\com\google\code\gson\gson\2.2.4\gson-2.2.4.jar;E:\maven-repository\repository\com\jcraft\jsch\0.1.54\jsch-0.1.54.jar;E:\maven-repository\repository\org\apache\curator\curator-client\2.7.1\curator-client-2.7.1.jar;E:\maven-repository\repository\org\apache\curator\curator-recipes\2.7.1\curator-recipes-2.7.1.jar;E:\maven-repository\repository\org\apache\hadoop\hadoop-auth\2.7.4\hadoop-auth-2.7.4.jar;E:\maven-repository\repository\org\apache\directory\server\apacheds-kerberos-codec\2.0.0-M15\apacheds-kerberos-codec-2.0.0-M15.jar;E:\maven-repository\repository\org\apache\directory\server\apacheds-i18n\2.0.0-M15\apacheds-i18n-2.0.0-M15.jar;E:\maven-repository\repository\org\apache\directory\api\api-asn1-api\1.0.0-M20\api-asn1-api-1.0.0-M20.jar;E:\maven-repository\repository\org\apache\directory\api\api-util\1.0.0-M20\api-util-1.0.0-M20.jar;E:\maven-repository\repository\org\apache\curator\curator-framework\2.7.1\curator-framework-2.7.1.jar;E:\maven-repository\repository\org\apache\hadoop\hadoop-client\2.7.4\hadoop-client-2.7.4.jar;E:\maven-repository\repository\org\apache\hadoop\hadoop-mapreduce-client-app\2.7.4\hadoop-mapreduce-client-app-2.7.4.jar;E:\maven-repository\repository\org\apache\hadoop\hadoop-mapreduce-client-common\2.7.4\hadoop-mapreduce-client-common-2.7.4.jar;E:\maven-repository\repository\org\apache\hadoop\hadoop-yarn-client\2.7.4\hadoop-yarn-client-2.7.4.jar;E:\maven-repository\repository\org\apache\hadoop\hadoop-yarn-server-common\2.7.4\hadoop-yarn-server-common-2.7.4.jar;E:\maven-repository\repository\org\apache\hadoop\hadoop-mapreduce-client-shuffle\2.7.4\hadoop-mapreduce-client-shuffle-2.7.4.jar;E:\maven-repository\repository\org\apache\hadoop\hadoop-yarn-api\2.7.4\hadoop-yarn-api-2.7.4.jar;E:\maven-repository\repository\org\apache\hadoop\hadoop-mapreduce-client-jobclient\2.7.4\hadoop-mapreduce-client-jobclient-2.7.4.jar;E:\maven-repository\repository\org\apache\hadoop\hadoop-mapreduce-client-core\2.7.4\hadoop-mapreduce-client-core-2.7.4.jar;E:\maven-repository\repository\org\apache\hadoop\hadoop-yarn-common\2.7.4\hadoop-yarn-common-2.7.4.jar;E:\maven-repository\repository\javax\xml\bind\jaxb-api\2.2.2\jaxb-api-2.2.2.jar;E:\maven-repository\repository\javax\xml\stream\stax-api\1.0-2\stax-api-1.0-2.jar;E:\maven-repository\repository\javax\activation\activation\1.1\activation-1.1.jar;E:\maven-repository\repository\javax\servlet\servlet-api\2.5\servlet-api-2.5.jar;E:\maven-repository\repository\com\sun\jersey\jersey-client\1.9\jersey-client-1.9.jar;E:\maven-repository\repository\com\google\inject\guice\3.0\guice-3.0.jar;E:\maven-repository\repository\javax\inject\javax.inject\1\javax.inject-1.jar;E:\maven-repository\repository\aopalliance\aopalliance\1.0\aopalliance-1.0.jar;E:\maven-repository\repository\com\sun\jersey\contribs\jersey-guice\1.9\jersey-guice-1.9.jar;E:\maven-repository\repository\com\google\inject\extensions\guice-servlet\3.0\guice-servlet-3.0.jar;E:\maven-repository\repository\org\apache\hadoop\hadoop-hdfs\2.7.4\hadoop-hdfs-2.7.4.jar;E:\maven-repository\repository\commons-daemon\commons-daemon\1.0.13\commons-daemon-1.0.13.jar;E:\maven-repository\repository\org\fusesource\leveldbjni\leveldbjni-all\1.8\leveldbjni-all-1.8.jar;E:\maven-repository\repository\junit\junit\4.12\junit-4.12.jar;E:\maven-repository\repository\org\hamcrest\hamcrest-core\1.3\hamcrest-core-1.3.jar;E:\maven-repository\repository\io\netty\netty-all\4.1.44.Final\netty-all-4.1.44.Final.jar;D:\Program
Files\ideaIU-2018.3.3.win\lib\idea_rt.jar
14:25:53,147 INFO  org.apache.zookeeper.ZooKeeper                              
- Client environment:java.library.path=C:\Program
Files\Java\jdk1.8.0_191\bin;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;C:\Program
Files (x86)\Common
Files\Oracle\Java\javapath;C:\ProgramData\Oracle\Java\javapath;C:\Program
Files\Java\jdk1.8.0_191\bin;h:\oracle\product\10.2.0\client_1\bin;C:\Program
Files (x86)\Common Files\NetSarang;C:\Program Files (x86)\Intel\iCLS
Client\;C:\Program Files\Intel\iCLS
Client\;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program
Files (x86)\ATI Technologies\ATI.ACE\Core-Static;C:\Program
Files\Intel\Intel(R) Management Engine Components\DAL;C:\Program
Files\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files
(x86)\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files
(x86)\Intel\Intel(R) Management Engine Components\IPT;C:\Program
Files\TortoiseSVN\bin;D:\apache-maven-3.5.0\bin;C:\Program
Files\Java\jdk1.8.0_191\bin;C:\Program
Files\Scala\scala-2.11.4\bin;C:\Program Files\TortoiseGit\bin;d:\Program
Files\Anaconda3;d:\Program Files\Anaconda3\Scripts;d:\Program
Files\Anaconda3\Library\bin;C:\Program Files\PuTTY\;c:\Program
Files\Git\cmd;C:\Program Files\EsafeNet\Cobra DocGuard
Client;C:\Users\xufuquan\AppData\Local\BypassRuntm;.
14:25:53,147 INFO  org.apache.zookeeper.ZooKeeper                              
- Client environment:java.io.tmpdir=C:\Users\xufuquan\AppData\Local\Temp\
14:25:53,147 INFO  org.apache.zookeeper.ZooKeeper                              
- Client environment:java.compiler=<NA>
14:25:53,148 INFO  org.apache.zookeeper.ZooKeeper                              
- Client environment:os.name=Windows 7
14:25:53,148 INFO  org.apache.zookeeper.ZooKeeper                              
- Client environment:os.arch=amd64
14:25:53,148 INFO  org.apache.zookeeper.ZooKeeper                              
- Client environment:os.version=6.1
14:25:53,148 INFO  org.apache.zookeeper.ZooKeeper                              
- Client environment:user.name=xufuquan
14:25:53,148 INFO  org.apache.zookeeper.ZooKeeper                              
- Client environment:user.home=C:\Users\xufuquan
14:25:53,148 INFO  org.apache.zookeeper.ZooKeeper                              
- Client environment:user.dir=F:\Workspaces\IDEA2018\log-analyse
14:25:53,148 INFO  org.apache.zookeeper.ZooKeeper                              
- Initiating client connection,
connectString=172.26.100.203:2181,172.26.100.204:2181,172.26.100.205:2181
sessionTimeout=90000
watcher=org.apache.hadoop.hbase.zookeeper.PendingWatcher@7b430469
14:25:53,157 INFO  org.apache.zookeeper.ClientCnxn                              
- Opening socket connection to server 172.26.100.205/172.26.100.205:2181.
Will not attempt to authenticate using SASL (unknown error)
14:25:53,159 INFO  org.apache.zookeeper.ClientCnxn                              
- Socket connection established to 172.26.100.205/172.26.100.205:2181,
initiating session
14:25:53,164 INFO  org.apache.zookeeper.ClientCnxn                              
- Session establishment complete on server
172.26.100.205/172.26.100.205:2181, sessionid = 0x1731883652c7698,
negotiated timeout = 90000
14:25:53,445 INFO  org.apache.flink.runtime.jobmaster.JobMaster                
- Successfully ran initialization on master in 598 ms.
14:26:02,806 INFO  org.apache.flink.runtime.minicluster.MiniCluster            
- Shutting down Flink Mini Cluster
14:26:02,806 INFO  org.apache.flink.runtime.taskexecutor.TaskExecutor          
- Stopping TaskExecutor akka://flink/user/rpc/taskmanager_0.
14:26:02,806 INFO  org.apache.flink.runtime.taskexecutor.TaskExecutor          
- Close ResourceManager connection 11bde3f1c60495c9700853463904dd89.
14:26:02,806 INFO
org.apache.flink.runtime.dispatcher.DispatcherRestEndpoint    - Shutting
down rest endpoint.
14:26:02,806 INFO
org.apache.flink.runtime.resourcemanager.StandaloneResourceManager  -
Closing TaskExecutor connection d0b1f67e-e303-4363-ad1c-24bd80702892
because: The TaskExecutor is shutting down.
14:26:02,813 INFO
org.apache.flink.runtime.taskexecutor.DefaultJobLeaderService  - Stop job
leader service.
14:26:02,813 INFO
org.apache.flink.runtime.state.TaskExecutorLocalStateStoresManager  -
Shutting down TaskExecutorLocalStateStoresManager.
14:26:02,823 INFO  org.apache.flink.runtime.io.disk.FileChannelManagerImpl      
- FileChannelManager removed spill file directory
C:\Users\xufuquan\AppData\Local\Temp\flink-io-b354fbd8-8742-4f42-a615-645acc877dd1
14:26:02,823 INFO
org.apache.flink.runtime.io.network.NettyShuffleEnvironment   - Shutting
down the network environment and its components.
14:26:02,826 INFO  org.apache.flink.runtime.io.disk.FileChannelManagerImpl      
- FileChannelManager removed spill file directory
C:\Users\xufuquan\AppData\Local\Temp\flink-netty-shuffle-9bb16fd0-4b97-43ce-b055-5dac35a91e71
14:26:02,826 INFO  org.apache.flink.runtime.taskexecutor.KvStateService        
- Shutting down the kvState service and its components.
14:26:02,826 INFO
org.apache.flink.runtime.taskexecutor.DefaultJobLeaderService  - Stop job
leader service.
14:26:02,827 INFO  org.apache.flink.runtime.filecache.FileCache                
- removed file cache directory
C:\Users\xufuquan\AppData\Local\Temp\flink-dist-cache-85fde370-d9f9-425a-a021-fabcaceeddce
Exception in thread "main" org.apache.flink.table.api.TableException: Failed
to execute sql
        at
org.apache.flink.table.api.internal.TableEnvironmentImpl.executeInternal(TableEnvironmentImpl.java:721)
        at
org.apache.flink.table.api.internal.StatementSetImpl.execute(StatementSetImpl.java:97)
        at
itoa.analyse.AnalyseFlinkSqlTestHbase.main(AnalyseFlinkSqlTestHbase.java:130)
Caused by: org.apache.flink.util.FlinkException: Failed to execute job
'insert-into_default_catalog.default_database.testhbase'.
        at
org.apache.flink.streaming.api.environment.StreamExecutionEnvironment.executeAsync(StreamExecutionEnvironment.java:1821)
        at
org.apache.flink.table.planner.delegation.ExecutorBase.executeAsync(ExecutorBase.java:57)
        at
org.apache.flink.table.api.internal.TableEnvironmentImpl.executeInternal(TableEnvironmentImpl.java:705)
        ... 2 more
14:26:02,828 INFO
org.apache.flink.runtime.dispatcher.DispatcherRestEndpoint    - Removing
cache directory C:\Users\xufuquan\AppData\Local\Temp\flink-web-ui
Caused by: java.util.concurrent.TimeoutException: Invocation of public
abstract java.util.concurrent.CompletableFuture
org.apache.flink.runtime.dispatcher.DispatcherGateway.submitJob(org.apache.flink.runtime.jobgraph.JobGraph,org.apache.flink.api.common.time.Time)
timed out.
        at com.sun.proxy.$Proxy49.submitJob(Unknown Source)
        at
org.apache.flink.runtime.minicluster.MiniCluster.lambda$submitJob$14(MiniCluster.java:690)
        at
java.util.concurrent.CompletableFuture.biApply(CompletableFuture.java:1105)
        at
java.util.concurrent.CompletableFuture$BiApply.tryFire(CompletableFuture.java:1070)
        at
java.util.concurrent.CompletableFuture.postComplete(CompletableFuture.java:474)
        at
java.util.concurrent.CompletableFuture.complete(CompletableFuture.java:1962)
        at
org.apache.flink.runtime.rpc.akka.AkkaInvocationHandler.lambda$invokeRpc$0(AkkaInvocationHandler.java:229)
        at
java.util.concurrent.CompletableFuture.uniWhenComplete(CompletableFuture.java:760)
        at
java.util.concurrent.CompletableFuture$UniWhenComplete.tryFire(CompletableFuture.java:736)
        at
java.util.concurrent.CompletableFuture.postComplete(CompletableFuture.java:474)
        at
java.util.concurrent.CompletableFuture.complete(CompletableFuture.java:1962)
        at
org.apache.flink.runtime.concurrent.FutureUtils$1.onComplete(FutureUtils.java:892)
        at akka.dispatch.OnComplete.internal(Future.scala:264)
        at akka.dispatch.OnComplete.internal(Future.scala:261)
        at akka.dispatch.japi$CallbackBridge.apply(Future.scala:191)
        at akka.dispatch.japi$CallbackBridge.apply(Future.scala:188)
        at scala.concurrent.impl.CallbackRunnable.run(Promise.scala:36)
        at
org.apache.flink.runtime.concurrent.Executors$DirectExecutionContext.execute(Executors.java:74)
        at
scala.concurrent.impl.CallbackRunnable.executeWithValue(Promise.scala:44)
        at
scala.concurrent.impl.Promise$DefaultPromise.tryComplete(Promise.scala:252)
        at akka.pattern.PromiseActorRef.$bang(AskSupport.scala:572)
        at
akka.pattern.PipeToSupport$PipeableFuture$$anonfun$pipeTo$1.applyOrElse(PipeToSupport.scala:22)
        at
akka.pattern.PipeToSupport$PipeableFuture$$anonfun$pipeTo$1.applyOrElse(PipeToSupport.scala:21)
        at scala.concurrent.Future$$anonfun$andThen$1.apply(Future.scala:436)
        at scala.concurrent.Future$$anonfun$andThen$1.apply(Future.scala:435)
        at scala.concurrent.impl.CallbackRunnable.run(Promise.scala:36)
        at
akka.dispatch.BatchingExecutor$AbstractBatch.processBatch(BatchingExecutor.scala:55)
        at
akka.dispatch.BatchingExecutor$BlockableBatch$$anonfun$run$1.apply$mcV$sp(BatchingExecutor.scala:91)
        at
akka.dispatch.BatchingExecutor$BlockableBatch$$anonfun$run$1.apply(BatchingExecutor.scala:91)
        at
akka.dispatch.BatchingExecutor$BlockableBatch$$anonfun$run$1.apply(BatchingExecutor.scala:91)
        at scala.concurrent.BlockContext$.withBlockContext(BlockContext.scala:72)
        at
akka.dispatch.BatchingExecutor$BlockableBatch.run(BatchingExecutor.scala:90)
        at akka.dispatch.TaskInvocation.run(AbstractDispatcher.scala:40)
        at
akka.dispatch.ForkJoinExecutorConfigurator$AkkaForkJoinTask.exec(ForkJoinExecutorConfigurator.scala:44)
        at akka.dispatch.forkjoin.ForkJoinTask.doExec(ForkJoinTask.java:260)
        at
akka.dispatch.forkjoin.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1339)
        at akka.dispatch.forkjoin.ForkJoinPool.runWorker(ForkJoinPool.java:1979)
        at
akka.dispatch.forkjoin.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:107)
14:26:02,829 INFO  org.apache.flink.runtime.taskexecutor.TaskExecutor          
- Stopped TaskExecutor akka://flink/user/rpc/taskmanager_0.
Caused by: akka.pattern.AskTimeoutException: Ask timed out on
[Actor[akka://flink/user/rpc/dispatcher_2#1923967099]] after [10000 ms].
Message of type [org.apache.flink.runtime.rpc.messages.LocalFencedMessage].
A typical reason for `AskTimeoutException` is that the recipient actor
didn't send a reply.
        at akka.pattern.PromiseActorRef$$anonfun$2.apply(AskSupport.scala:635)
        at akka.pattern.PromiseActorRef$$anonfun$2.apply(AskSupport.scala:635)
        at
akka.pattern.PromiseActorRef$$anonfun$1.apply$mcV$sp(AskSupport.scala:648)
        at akka.actor.Scheduler$$anon$4.run(Scheduler.scala:205)
        at
scala.concurrent.Future$InternalCallbackExecutor$.unbatchedExecute(Future.scala:601)
        at
scala.concurrent.BatchingExecutor$class.execute(BatchingExecutor.scala:109)
        at
scala.concurrent.Future$InternalCallbackExecutor$.execute(Future.scala:599)
        at
akka.actor.LightArrayRevolverScheduler$TaskHolder.executeTask(LightArrayRevolverScheduler.scala:328)
        at
akka.actor.LightArrayRevolverScheduler$$anon$4.executeBucket$1(LightArrayRevolverScheduler.scala:279)
        at
akka.actor.LightArrayRevolverScheduler$$anon$4.nextTick(LightArrayRevolverScheduler.scala:283)
        at
akka.actor.LightArrayRevolverScheduler$$anon$4.run(LightArrayRevolverScheduler.scala:235)
        at java.lang.Thread.run(Thread.java:748)
14:26:02,830 INFO
org.apache.flink.runtime.dispatcher.DispatcherRestEndpoint    - Shut down
complete.
14:26:02,832 INFO
org.apache.flink.runtime.resourcemanager.StandaloneResourceManager  - Shut
down cluster because application is in CANCELED, diagnostics
DispatcherResourceManagerComponent has been closed..
14:26:02,832 INFO
org.apache.flink.runtime.entrypoint.component.DispatcherResourceManagerComponent
- Closing components.
14:26:02,833 INFO
org.apache.flink.runtime.dispatcher.runner.SessionDispatcherLeaderProcess  -
Stopping SessionDispatcherLeaderProcess.
14:26:02,833 INFO  org.apache.flink.runtime.dispatcher.StandaloneDispatcher    
- Stopping dispatcher akka://flink/user/rpc/dispatcher_2.
14:26:02,833 INFO  org.apache.flink.runtime.dispatcher.StandaloneDispatcher    
- Stopping all currently running jobs of dispatcher
akka://flink/user/rpc/dispatcher_2.
14:26:02,833 INFO
org.apache.flink.runtime.resourcemanager.slotmanager.SlotManagerImpl  -
Closing the SlotManager.
14:26:02,833 INFO
org.apache.flink.runtime.resourcemanager.slotmanager.SlotManagerImpl  -
Suspending the SlotManager.








我的源表、维表,测试表的结构见下面:

  source.kafka: >
    create table applog (
      eventTime bigint
      ,host varchar
      ,times timestamp(3)
      ,commandId integer
      ,terminalNo bigint
      ,loginId bigint
      ,ip varchar
      ,errCode integer
      ,respTime integer
      ,attr integer
      ,sequence varchar
      ,tid varchar
      ,checksum varchar
      ,version varchar
      ,proc_time as proctime()
      ,watermark for times as times - interval '5' second
    )
    with(
     'connector' = 'kafka-0.10',
                …………
     'scan.startup.mode' = 'latest-offset',
     'format' = 'json'
    )

  source.hbase: >
      create table shop (
        rowkey varchar
        ,cf1 ROW<province_center_id varchar,city_center_id
varchar,county_center_id varchar>
        ,PRIMARY KEY (rowkey) NOT ENFORCED
      )
      with(
        'connector' = 'hbase-1.4',
        'zookeeper.quorum' = '…………',
        'table-name' = '…………'
       )

  sink.jdbc: >
    create table cas_analyse_active_daily_1 (
      request_date varchar
      ,request_id integer
      ,province_center_id integer
      ,terminal_cnt bigint
      ,insert_time varchar
      ,PRIMARY KEY (request_date,request_id,province_center_id) NOT ENFORCED
    ) with (
      'connector' = 'jdbc',
      …………
    )

  sink.kafka: >
    create table testhbase (
      rowkey varchar

    ) with (
      'connector' = 'kafka-0.10',
      'topic' = 'testhbase',
      …………
      'format' = 'json'
    )

  select.sql1: >
    insert into testhbase
        select cast(applog.terminalNo as varchar)
        from applog INNER join shop  for system_time as of applog.proc_time
                                   on cast(applog.terminalNo as varchar)=
shop.rowkey



--
Sent from: http://apache-flink.147419.n8.nabble.com/

Reply | Threaded
Open this post in threaded view
|

Re: flink 1.11.1 使用sql ,使用hbase作为维表进行temporal join时无法获取数据

鱼子酱
重新搞了一下,找到原因了
1、没有配置hbase的host
Reading reply sessionid:0x3000484bfd0001d, packet:: clientPath:null
serverPath:null finish

2、protobuf-java版本过高
java.lang.NoClassDefFoundError: com/google/protobuf/LiteralByteString


这个2个问题一直没发现,是因为报错的信息只有debug级别里面有,我之前的日志级别是info,希望后续如果可能的话,把相关的报错的信息提高级别就更好识别啦



--
Sent from: http://apache-flink.147419.n8.nabble.com/