• flink-sql-gateway:Caused by: org.apache.flink.table.api.NoMatchingTableFactoryException: Could not find a suitable table factory for 'org.apache.flink.table.factories.CatalogFactory' in the classpath.


    while I add catalogs in sql-gateway-defaults.yaml:
    catalogs:
    
    name: catalog_hive
    type: hive
    hive-conf-dir: /opt/software/flink-sql-gateway-0.1-SNAPSHOT/conf //include hive-site.xml
    the error below happens,help please.
    
    Caused by: org.apache.flink.table.api.NoMatchingTableFactoryException: Could not find a suitable table factory for 'org.apache.flink.table.factories.CatalogFactory' in
    the classpath.
    
    Reason: Required context properties mismatch.
    
    The following properties are requested:
    hive-conf-dir=/opt/software/flink-sql-gateway-0.1-SNAPSHOT/conf
    type=hive
    
    The following factories have been considered:
    org.apache.flink.table.catalog.GenericInMemoryCatalogFactory
    at org.apache.flink.table.factories.TableFactoryService.filterByContext(TableFactoryService.java:322)
    at org.apache.flink.table.factories.TableFactoryService.filter(TableFactoryService.java:190)
    at org.apache.flink.table.factories.TableFactoryService.findSingleInternal(TableFactoryService.java:143)
    at org.apache.flink.table.factories.TableFactoryService.find(TableFactoryService.java:113)
    at com.ververica.flink.table.gateway.context.ExecutionContext.createCatalog(ExecutionContext.java:364)
    at com.ververica.flink.table.gateway.context.ExecutionContext.lambda$null$4(ExecutionContext.java:543)
    at java.util.HashMap.forEach(HashMap.java:1288)
    at com.ververica.flink.table.gateway.context.ExecutionContext.lambda$initializeCatalogs$5(ExecutionContext.java:542)
    at com.ververica.flink.table.gateway.context.ExecutionContext.wrapClassLoader(ExecutionContext.java:239)
    at com.ververica.flink.table.gateway.context.ExecutionContext.initializeCatalogs(ExecutionContext.java:541)
    at com.ververica.flink.table.gateway.context.ExecutionContext.initializeTableEnvironment(ExecutionContext.java:490)
    at com.ververica.flink.table.gateway.context.ExecutionContext.(ExecutionContext.java:159)
    at com.ververica.flink.table.gateway.context.ExecutionContext.(ExecutionContext.java:118)
    at com.ververica.flink.table.gateway.context.ExecutionContext$Builder.build(ExecutionContext.java:751)
    ... 46 more

    准备两个jar包。flink-connector-hive_2.11-1.11.1.jar和hive-exec-2.1.1.jar

    可以放在flink-sql-gateway的lib/或者flink的lib/

  • 相关阅读:
    抓包来看ftp状态码
    socket基础篇
    密码复杂度检查函数
    time模块
    读取日志文件,搜索关键字,打印关键字前5行。yield、deque实例
    装饰器--函数
    yield用法
    字符编码
    pycharm + git实现两台电脑代码同步
    PyCharm常见用法
  • 原文地址:https://www.cnblogs.com/felixzh/p/13572384.html
Copyright © 2020-2023  润新知