flink1.10中hive module 没有plus,greaterThan等函数

2020-08-20 Thread faaron zheng
Hi all, 我在使用flink1.10的sql-client时候发现使用hive module时会缺少某些core module 中的build-in function比如plus,greaterThan。这会导致同样的sql core module可以执行成功,hive module却会报错,比如在使用row_number() over()时候。这是什么原因?

Any idea for data skew in hash join

2020-07-07 Thread faaron zheng
Hi, all, I use flink 1.10 to run a sql and I find that almost 60% of the data is concentrated on one parallelism. Is there any good idea for this scene?

Re: The parallelism of sink is always 1 in sqlUpdate

2020-03-06 Thread faaron zheng
ory/mem_setup.html#managed-memory > > Best, > Jingsong Lee > > On Fri, Mar 6, 2020 at 5:38 PM faaron zheng wrote: > >> Hi all, >> >> I am trying to use flink sql to run hive task. I use tEnv.sqlUpdate to >> execute my sql which looks like "insert overtwrite

The parallelism of sink is always 1 in sqlUpdate

2020-03-06 Thread faaron zheng
Hi all, I am trying to use flink sql to run hive task. I use tEnv.sqlUpdate to execute my sql which looks like "insert overtwrite ... select ...". But I find the parallelism of sink is always 1, it's intolerable for large data. Why it happens? Otherwise, Is there any guide to decide the memory of

Re: Question about runtime filter

2020-03-04 Thread faaron zheng
ope it helps if anyone try to do same thing. faaron zheng 于 2020年3月2日周一 下午7:52写道: > I set sql.exec.runtime-filter.wait to true. HiveTableSource take much > longer time but get same result. I think the reason is not commit > preAggregateAccumulator. But I dont know why it happens? > >

Re: Question about runtime filter

2020-03-02 Thread faaron zheng
I set sql.exec.runtime-filter.wait to true. HiveTableSource take much longer time but get same result. I think the reason is not commit preAggregateAccumulator. But I dont know why it happens? JingsongLee 于 2020年3月2日周一 下午3:22写道: > Hi, > > Does runtime filter probe side wait for building runtime

Re: Question about runtime filter

2020-03-02 Thread faaron zheng
Thanks for replying Lee, I follow your method to debug the code and I find the build side only call addPreAggregatedAccumulator but not call commit method. Furthermore, I add a breakpoint at future.handleAsync in asyncGetBroadcastBloomFilter method. But when program stop at if(e==null && accumulat

Question about runtime filter

2020-03-01 Thread faaron zheng
Hi, everyone These days, I am trying to implement runtime filter in flink1.10 with flink-sql-benchmark according to blink. I mainly change three part of flink code: add runtime filter rule; modify the code gen and bloomfilter; add some aggregatedaccumulator methods according to accumulator. Now,