>>>> DATE_FORMAT(TUMBLE_ROWTIME(rowtime, INTERVAL '1' DAY), '-MM-dd'),
>>>> ROW(
>>>> platform_id,
>>>> content_id
>>>> )
>>>> FROM content_event
>>>> GROUP BY
>>&g
content_id
> )
> FROM content_event
> GROUP BY
> platform_id,
> content_id,
> TUMBLE(rowtime, INTERVAL '1' DAY)
>
> SELECT * FROM test_content_metrics_view
>
>
> On Wed, Nov 23, 2022 at 1:19 PM Dan Hill <mailto:quietgol...@gmail
.16.0 and I get the same error.
>>>>
>>>> On Wed, Nov 23, 2022 at 9:47 AM Dan Hill wrote:
>>>>
>>>>> For the error `Encountered "." at line 1, column 119.`, here are the
>>>>> confusing parts:
>>>>>
>>>>> 1. The error happens when I
hat SQL statement.
>>>> 3. None of the SQL that I've written has a period "." in it.
>>>>
>>>>
>>>>
>>>> On Wed, Nov 23, 2022 at 8:32 AM Dan Hill wrote:
>>>>
>>>>> I'm using Flink 1.14.4
>>>>>
>>>>>
v 23, 2022, 02:28 yuxia wrote:
>>>>
>>>>> Hi, Dan.
>>>>> I'm wondering what type of error you expect. IMO, I think most engines
>>>>> throw parse error in such way which tell you encounter an unexpected
>>>>> token.
; I'm wondering what type of error you expect. IMO, I think most engines
>>>> throw parse error in such way which tell you encounter an unexpected token.
>>>>
>>>> Best regards,
>>>> Yuxia
>>>>
>>>> ---
nter an unexpected token.
>>>
>>> Best regards,
>>> Yuxia
>>>
>>> --
>>> *发件人: *"Dan Hill"
>>> *收件人: *"User"
>>> *发送时间: *星期三, 2022年 11 月 23日 下午 1:55:20
>>> *主题: *Weird
pect. IMO, I think most engines
>> throw parse error in such way which tell you encounter an unexpected token.
>>
>> Best regards,
>> Yuxia
>>
>> ------
>> *发件人: *"Dan Hill"
>> *收件人: *"User"
>> *发送时
---
> *发件人: *"Dan Hill"
> *收件人: *"User"
> *发送时间: *星期三, 2022年 11 月 23日 下午 1:55:20
> *主题: *Weird Flink SQL error
>
> Hi. I'm hitting an obfuscated Flink SQL parser error. Is there a way to
> get better errors for Flink SQL
Hi, Dan.
I'm wondering what type of error you expect. IMO, I think most engines throw
parse error in such way which tell you encounter an unexpected token.
Best regards,
Yuxia
发件人: "Dan Hill"
收件人: "User"
发送时间: 星期三, 2022年 11 月 23日 下午 1:55:20
主题: Weird Flink SQ
Hi Dan,
Which Flink version do you apply? I write a test case base on the code
snippet you provided and it works normally in Flink 1.17-SNAPSHOT.
Best,
Shuiqiang
Dan Hill 于2022年11月23日周三 13:55写道：
> Hi. I'm hitting an obfuscated Flink SQL parser error. Is there a way to
> get better errors for
Hi. I'm hitting an obfuscated Flink SQL parser error. Is there a way to
get better errors for Flink SQL? I'm hitting it when I wrap some of the
fields on an inner Row.
*Works*
CREATE TEMPORARY VIEW `test_content_metrics_view` AS
SELECT
DATE_FORMAT(TUMBLE_ROWTIME(rowtime, INTERVAL '1' DAY)
12 matches
Mail list logo
