Re: Flink sql 中 无法通过 TableEnvironment 调出 createTemporaryTable()方法 以及.TableException: findAndCreateTableSource failed 异常

2020-06-09 Thread Px New
://imgkr.cn-bj.ufileos.com/579e5336-503c-490f-83b9-ebb46bd1b568.png > > 图 4 (官网格式): > > https://imgkr.cn-bj.ufileos.com/fcc7365e-aecf-49a3-94e1-ae64ee67122e.png > > 图5 (TableException: findAndCreateTableSource failed 异常) > > https://imgkr.cn-bj.ufileos.com/386a783a-a42e-4466-97f8-540adb524be0.PNG > > 以及: > > https://imgkr.cn-bj.ufileos.com/9cac88cc-7601-4b03-ade1-f2432c84adac.PNG > > > > > -- > > Best, > Benchao Li >

Re: Flink sql 中 无法通过 TableEnvironment 调出 createTemporaryTable()方法 以及.TableException: findAndCreateTableSource failed 异常

2020-06-08 Thread Benchao Li
/imgkr.cn-bj.ufileos.com/e19b90f7-ef60-42d8-a93e-d65c4269e053.png > 图 3 (无法调用?): > https://imgkr.cn-bj.ufileos.com/579e5336-503c-490f-83b9-ebb46bd1b568.png > 图 4 (官网格式): > https://imgkr.cn-bj.ufileos.com/fcc7365e-aecf-49a3-94e1-ae64ee67122e.png > 图5 (TableException: findAndCreateTableSo

Flink sql 中 无法通过 TableEnvironment 调出 createTemporaryTable()方法 以及.TableException: findAndCreateTableSource failed 异常

2020-06-08 Thread Px New
-49a3-94e1-ae64ee67122e.png 图5 (TableException: findAndCreateTableSource failed 异常) https://imgkr.cn-bj.ufileos.com/386a783a-a42e-4466-97f8-540adb524be0.PNG 以及: https://imgkr.cn-bj.ufileos.com/9cac88cc-7601-4b03-ade1-f2432c84adac.PNG

Re: TableException

2019-06-12 Thread JingsongLee
Hi Pramit: AppendStreamTableSink defines an external TableSink to emit a streaming table with only insert changes. If the table is also modified by update or delete changes, a TableException will be thrown.[1] Your sql seems have update or delete changes. You can try to use

TableException

2019-06-12 Thread Pramit Vamsi
Hi, I am attempting the following: String sql = "INSERT INTO table3 " + "SELECT col1, col2, window_start_time , window_end_time , MAX(col3), MAX(col4), MAX(col5) FROM " + "(SELECT col1,col2, " + "TUMBLE_START(ts, INTERVAL '1' MINUTE) as window_start_time, "

Re: Flink 1.4 SQL API Streaming TableException

2018-03-09 Thread Pavel Ciorba
Bill Lee, Man, you saved me from headbanging :) Thank you! 2018-03-10 0:25 GMT+02:00 杨力 : > To use a field in a table as timestamp, it must be declared as a rowtime > attribute for the table. > > 1) Call env.setStreamTimeCharacteristic(TimeCharacteristic.EventTime). > 2)

Re: Flink 1.4 SQL API Streaming TableException

2018-03-09 Thread 杨力
To use a field in a table as timestamp, it must be declared as a rowtime attribute for the table. 1) Call env.setStreamTimeCharacteristic(TimeCharacteristic.EventTime). 2) Call withRowtimeAttribute on KafkaJsonTableSourceBuilder. Reference: 1.

Flink 1.4 SQL API Streaming TableException

2018-03-09 Thread Pavel Ciorba
Hi everyone! I decided to try the Time-windowed join functionality of Flink 1.4+. My SQL query is an exact copy of the example in the documentation, and the program reads and writes from Kafka. I used the example from here:

Re: TableException: GenericTypeInfo cannot be converted to Table

2017-12-08 Thread Sendoh
Thanks! don't know this works as well. Cheers, Sendoh -- Sent from: http://apache-flink-user-mailing-list-archive.2336050.n4.nabble.com/

Re: TableException: GenericTypeInfo cannot be converted to Table

2017-12-08 Thread Fabian Hueske
Yes. Adding .returns(typeInfo) works as well. :-) 2017-12-08 11:29 GMT+01:00 Fabian Hueske : > Hi, > > you give the TypeInformation to your user code but you don't expose it to > the DataStream API (the code of the FlatMapFunction is a black box for the > API). > You're

Re: TableException: GenericTypeInfo cannot be converted to Table

2017-12-08 Thread Fabian Hueske
Hi, you give the TypeInformation to your user code but you don't expose it to the DataStream API (the code of the FlatMapFunction is a black box for the API). You're FlatMapFunction should implement the ResultTypeQueryable interface and return the TypeInformation. Best, Fabian 2017-12-08 11:19

Re: TableException: GenericTypeInfo cannot be converted to Table

2017-12-08 Thread Sendoh
Found it. I should use .returns(typeInformation) after the map function. -- Sent from: http://apache-flink-user-mailing-list-archive.2336050.n4.nabble.com/

TableException: GenericTypeInfo cannot be converted to Table

2017-12-08 Thread Sendoh
Hi Flink users, I found the workarounds to resolve this exception in scala. https://issues.apache.org/jira/browse/FLINK-6500 But I already provide the TypeInformation when deserializing json object, and still see this exception. Is there anything I ignore? The sample code