miklosgergely commented on a change in pull request #902: HIVE-22866 schq testcases URL: https://github.com/apache/hive/pull/902#discussion_r380030431
########## File path: ql/src/test/queries/clientpositive/schq_ingest.q ########## @@ -0,0 +1,44 @@ +--! qt:authorizer +--! qt:scheduledqueryservice +--! qt:sysdb + +set user.name=hive_admin_user; +set role admin; + +drop table if exists t; +drop table if exists s; + +-- suppose that this table is an external table or something +-- which supports the pushdown of filter condition on the id column +create table s(id integer, cnt integer); + +-- create an internal table and an offset table +create table t(id integer, cnt integer); +create table t_offset(offset integer); +insert into t_offset values(0); + +-- pretend that data is added to s +insert into s values(1,1); + +-- run an ingestion... +from (select id==offset as first,* from s +join t_offset on id>=offset) s1 +insert into t select id,cnt where first = false Review comment: use "not first" instead of "first = false" ---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
