Re: 试用BlinkSQL发现一些问题

2019-02-26 文章 bigdatayunzhongyan
Sorry!

1、SQL解析有问题,无法识别formatted,desc xxx可以
Flink SQL> desc formatted customer;
[ERROR] Could not execute SQL statement. Reason:
org.apache.flink.table.api.TableException: Table 'formatted customer' was not 
found.

Flink SQL> desc customer;
root
 |-- name: c_customer_sk
 |-- type: IntType
 |-- isNullable: true

2、不支持hive外部表
Flink SQL> select * from customer limit 10;
[ERROR] Could not execute SQL statement. Reason:
org.apache.flink.table.api.NoMatchingTableFactoryException: Could not find a 
suitable table factory for 
'org.apache.flink.table.factories.BatchTableSourceFactory' in
the classpath.

Reason: 
The matching factory 
'org.apache.flink.streaming.connectors.hive.HiveTableFactory' doesn't support 
'external'.

3、Hive1.x版本兼容问题 desc 
 Invalid method name: 'get_table_req'


谢谢!
发件人: Jark Wu
发送时间: 2019-02-27 12:15:27
收件人:  user-zh@flink.apache.org
主题: Re: 试用BlinkSQL发现一些问题
Hi,

邮件列表不支持发图片,可以发图片的链接。

Thanks,
Jark

On Wed, 27 Feb 2019 at 11:17, bigdatayunzhongyan
 wrote:

>
> 大家好!
> 在试用BlinkSQL中发现一些问题,总结如下:
> Hive版本2.3.4
> 1、SQL解析有问题 无法识别formatted
>
> 2、不支持hive外部表
> 3、Hive1.x版本兼容问题
>
>


Re: 试用BlinkSQL发现一些问题

2019-02-26 文章 Jark Wu
Hi,

邮件列表不支持发图片,可以发图片的链接。

Thanks,
Jark

On Wed, 27 Feb 2019 at 11:17, bigdatayunzhongyan
 wrote:

>
> 大家好!
> 在试用BlinkSQL中发现一些问题,总结如下:
> Hive版本2.3.4
> 1、SQL解析有问题 无法识别formatted
>
> 2、不支持hive外部表
> 3、Hive1.x版本兼容问题
>
>


试用BlinkSQL发现一些问题

2019-02-26 文章 bigdatayunzhongyan

大家好!
在试用BlinkSQL中发现一些问题,总结如下:
Hive版本2.3.4
1、SQL解析有问题 无法识别formatted


2、不支持hive外部表

3、Hive1.x版本兼容问题



Re: [Blink]sql client kafka sink 失败

2019-02-26 文章 Zhenghua Gao
换个干净的环境(清除 standalone sql client 进程及日志, 然后reproduce你的问题),
然后把对应的 standalonesession, taskexecutor, 及 sql client日志传上来看看。


On Tue, Feb 26, 2019 at 10:43 AM 张洪涛  wrote:

>
>
> 如果把kafka connector shade jar放在blink lib 下面 然后启动是没有问题的  但是放在sql client
> --jar 参数就有问题
>
>
> 我又多测试了几遍 发现class not found的类 是随机的
>
>
> 有什么建议么?
>
>
> 2019-02-26 10:36:10,343 ERROR
> org.apache.flink.kafka011.shaded.org.apache.kafka.common.utils.KafkaThread
> - Uncaught exception in kafka-producer-network-thread | producer-1:
> java.lang.NoClassDefFoundError:
> org/apache/flink/kafka011/shaded/org/apache/kafka/common/requests/ProduceResponse$PartitionResponse
> at
> org.apache.flink.kafka011.shaded.org.apache.kafka.common.requests.ProduceResponse.(ProduceResponse.java:107)
> at
> org.apache.flink.kafka011.shaded.org.apache.kafka.common.requests.AbstractResponse.getResponse(AbstractResponse.java:55)
> at
> org.apache.flink.kafka011.shaded.org.apache.kafka.clients.NetworkClient.createResponse(NetworkClient.java:569)
> at
> org.apache.flink.kafka011.shaded.org.apache.kafka.clients.NetworkClient.handleCompletedReceives(NetworkClient.java:663)
> at
> org.apache.flink.kafka011.shaded.org.apache.kafka.clients.NetworkClient.poll(NetworkClient.java:442)
> at
> org.apache.flink.kafka011.shaded.org.apache.kafka.clients.producer.internals.Sender.run(Sender.java:224)
> at
> org.apache.flink.kafka011.shaded.org.apache.kafka.clients.producer.internals.Sender.run(Sender.java:162)
> at java.lang.Thread.run(Thread.java:745)
> Caused by: java.lang.ClassNotFoundException:
> org.apache.flink.kafka011.shaded.org.apache.kafka.common.requests.ProduceResponse$PartitionResponse
> at java.net.URLClassLoader.findClass(URLClassLoader.java:381)
> at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
> at
> org.apache.flink.runtime.execution.librarycache.FlinkUserCodeClassLoaders$ChildFirstClassLoader.loadClass(FlinkUserCodeClassLoaders.java:120)
> at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
>
>
>
>
> 在 2019-02-25 14:34:54,"Becket Qin"  写道:
> >@Kurt,
> >
> >这个是符合预期的。为了防止和用户code中可能的Kafka依赖发生冲突。
> >
> >On Mon, Feb 25, 2019 at 10:28 AM Kurt Young  wrote:
> >
> >> kafka的包看路径是shade过的,这是符合预期的吗? @Becket
> >>
> >> Best,
> >> Kurt
> >>
> >>
> >> On Mon, Feb 25, 2019 at 9:56 AM 张洪涛  wrote:
> >>
> >> >
> >> >
> >> > sql-client.sh 的启动参数首先在classpath里面会包含kafka相关的jar  另外会有--jar
> >> > 包含所有connector的jar
> >> >
> >> >
> >> > 这些jars在sql-client提交job时候会上传到cluster的blob store 但是很奇怪为啥找不到
> >> >
> >> >
> >> >  00:00:06 /usr/lib/jvm/java-1.8.0-openjdk/bin/java
> >> > -Dlog.file=/bigdata/flink-1.5.1/log/flink-root-sql-client-gpu06.log
> >> >
> -Dlog4j.configuration=file:/bigdata/flink-1.5.1/conf/log4j-cli.properties
> >> > -Dlogback.configurationFile=file:/bigdata/flink-1.5.1/conf/logback.xml
> >> > -classpath
> >> >
> >>
> /bigdata/flink-1.5.1/lib/flink-python_2.11-1.5.1.jar:/bigdata/flink-1.5.1/lib/flink-shaded-hadoop2-uber-1.5.1.jar:/bigdata/flink-1.5.1/lib/log4j-1.2.17.jar:/bigdata/flink-1.5.1/lib/slf4j-log4j12-1.7.7.jar:/bigdata/flink-1.5.1/lib/flink-dist_2.11-1.5.1.jar::/bigdata/hadoop-2.7.5/etc/hadoop::/bigdata/flink-1.5.1/opt/connectors/kafka011/flink-connector-kafka-0.11_2.11-1.5.1-sql-jar.jar:/bigdata/flink-1.5.1/opt/connectors/kafka010/flink-connector-kafka-0.10_2.11-1.5.1-sql-jar.jar:/bigdata/flink-1.5.1/opt/connectors/kafka09/flink-connector-kafka-0.9_2.11-1.5.1-sql-jar.jar:/bigdata/flink-1.5.1/opt/connectors/kafka08/flink-connector-kafka-0.8_2.11-1.5.1.jar:/bigdata/flink-1.5.1/opt/connectors/flink-hbase_2.11-1.5.1.jar:/bigdata/flink-1.5.1/opt/connectors/flink-connector-hadoop-compatibility_2.11-1.5.1.jar:/bigdata/flink-1.5.1/opt/connectors/flink-connector-hive_2.11-1.5.1.jar:/bigdata/flink-1.5.1/opt/sql-client/datanucleus-api-jdo-4.2.4.jar:/bigdata/flink-1.5.1/opt/sql-client/javax.jdo-3.2.0-m3.jar:/bigdata/flink-1.5.1/opt/sql-client/datanucleus-core-4.1.17.jar:/bigdata/flink-1.5.1/opt/sql-client/datanucleus-rdbms-4.1.19.jar:/bigdata/flink-1.5.1/opt/sql-client/flink-sql-client-1.5.1.jar
> >> > org.apache.flink.table.client.SqlClient embedded -d
> >> > conf/sql-client-defaults.yaml --jar
> >> >
> >>
> /bigdata/flink-1.5.1/opt/connectors/kafka011/flink-connector-kafka-0.11_2.11-1.5.1-sql-jar.jar
> >> > --jar
> >> >
> >>
> /bigdata/flink-1.5.1/opt/connectors/kafka010/flink-connector-kafka-0.10_2.11-1.5.1-sql-jar.jar
> >> > --jar
> >> >
> >>
> /bigdata/flink-1.5.1/opt/connectors/kafka09/flink-connector-kafka-0.9_2.11-1.5.1-sql-jar.jar
> >> > --jar
> >> >
> >>
> /bigdata/flink-1.5.1/opt/connectors/kafka08/flink-connector-kafka-0.8_2.11-1.5.1.jar
> >> > --jar /bigdata/flink-1.5.1/opt/connectors/flink-hbase_2.11-1.5.1.jar
> >> --jar
> >> >
> >>
> /bigdata/flink-1.5.1/opt/connectors/flink-connector-hadoop-compatibility_2.11-1.5.1.jar
> >> > --jar
> >> >
> /bigdata/flink-1.5.1/opt/connectors/flink-connector-hive_2.11-1.5.1.jar
> >> > --jar /bigdata/flink-1.5.1/opt/sql-client/flink-sql