[jira] [Updated] (HIVE-23230) HiveWarehouseConnector executeQuery api with query having "LIMIT" clause returns more rows
[ https://issues.apache.org/jira/browse/HIVE-23230?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Adesh Kumar Rao updated HIVE-23230: --- Status: In Progress (was: Patch Available) > HiveWarehouseConnector executeQuery api with query having "LIMIT" clause > returns more rows > -- > > Key: HIVE-23230 > URL: https://issues.apache.org/jira/browse/HIVE-23230 > Project: Hive > Issue Type: Bug > Components: HiveServer2 >Affects Versions: 3.1.0 >Reporter: Adesh Kumar Rao >Assignee: Adesh Kumar Rao >Priority: Major > Attachments: HIVE-23230.1.patch, HIVE-23230.patch > > > The issue is reproducible when number of llap daemons is greater than 1. > > How to reproduce: > run below commands via beeline to create and populate the table > > {noformat} > create table test (id int); > insert into table test values (1); > insert into table test values (2); > insert into table test values (3); > insert into table test values (4); > insert into table test values (5); > insert into table test values (6); > insert into table test values (7); > delete from test where id = 7;{noformat} > now running below query via spark-shell > {noformat} > import com.hortonworks.hwc.HiveWarehouseSession > val hive = HiveWarehouseSession.session(spark).build() > hive.executeQuery("select * from test limit 1").show(){noformat} > will return more than 1 rows. -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Updated] (HIVE-23230) HiveWarehouseConnector executeQuery api with query having "LIMIT" clause returns more rows
[ https://issues.apache.org/jira/browse/HIVE-23230?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Adesh Kumar Rao updated HIVE-23230: --- Status: Patch Available (was: In Progress) > HiveWarehouseConnector executeQuery api with query having "LIMIT" clause > returns more rows > -- > > Key: HIVE-23230 > URL: https://issues.apache.org/jira/browse/HIVE-23230 > Project: Hive > Issue Type: Bug > Components: HiveServer2 >Affects Versions: 3.1.0 >Reporter: Adesh Kumar Rao >Assignee: Adesh Kumar Rao >Priority: Major > Attachments: HIVE-23230.1.patch, HIVE-23230.patch > > > The issue is reproducible when number of llap daemons is greater than 1. > > How to reproduce: > run below commands via beeline to create and populate the table > > {noformat} > create table test (id int); > insert into table test values (1); > insert into table test values (2); > insert into table test values (3); > insert into table test values (4); > insert into table test values (5); > insert into table test values (6); > insert into table test values (7); > delete from test where id = 7;{noformat} > now running below query via spark-shell > {noformat} > import com.hortonworks.hwc.HiveWarehouseSession > val hive = HiveWarehouseSession.session(spark).build() > hive.executeQuery("select * from test limit 1").show(){noformat} > will return more than 1 rows. -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Updated] (HIVE-23230) HiveWarehouseConnector executeQuery api with query having "LIMIT" clause returns more rows
[ https://issues.apache.org/jira/browse/HIVE-23230?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Adesh Kumar Rao updated HIVE-23230: --- Attachment: HIVE-23230.1.patch > HiveWarehouseConnector executeQuery api with query having "LIMIT" clause > returns more rows > -- > > Key: HIVE-23230 > URL: https://issues.apache.org/jira/browse/HIVE-23230 > Project: Hive > Issue Type: Bug > Components: HiveServer2 >Affects Versions: 3.1.0 >Reporter: Adesh Kumar Rao >Assignee: Adesh Kumar Rao >Priority: Major > Attachments: HIVE-23230.1.patch, HIVE-23230.patch > > > The issue is reproducible when number of llap daemons is greater than 1. > > How to reproduce: > run below commands via beeline to create and populate the table > > {noformat} > create table test (id int); > insert into table test values (1); > insert into table test values (2); > insert into table test values (3); > insert into table test values (4); > insert into table test values (5); > insert into table test values (6); > insert into table test values (7); > delete from test where id = 7;{noformat} > now running below query via spark-shell > {noformat} > import com.hortonworks.hwc.HiveWarehouseSession > val hive = HiveWarehouseSession.session(spark).build() > hive.executeQuery("select * from test limit 1").show(){noformat} > will return more than 1 rows. -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Updated] (HIVE-23230) HiveWarehouseConnector executeQuery api with query having "LIMIT" clause returns more rows
[ https://issues.apache.org/jira/browse/HIVE-23230?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan updated HIVE-23230: Component/s: HiveServer2 Target Version/s: 4.0.0 > HiveWarehouseConnector executeQuery api with query having "LIMIT" clause > returns more rows > -- > > Key: HIVE-23230 > URL: https://issues.apache.org/jira/browse/HIVE-23230 > Project: Hive > Issue Type: Bug > Components: HiveServer2 >Affects Versions: 3.1.0 >Reporter: Adesh Kumar Rao >Assignee: Adesh Kumar Rao >Priority: Major > Attachments: HIVE-23230.patch > > > The issue is reproducible when number of llap daemons is greater than 1. > > How to reproduce: > run below commands via beeline to create and populate the table > > {noformat} > create table test (id int); > insert into table test values (1); > insert into table test values (2); > insert into table test values (3); > insert into table test values (4); > insert into table test values (5); > insert into table test values (6); > insert into table test values (7); > delete from test where id = 7;{noformat} > now running below query via spark-shell > {noformat} > import com.hortonworks.hwc.HiveWarehouseSession > val hive = HiveWarehouseSession.session(spark).build() > hive.executeQuery("select * from test limit 1").show(){noformat} > will return more than 1 rows. -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Updated] (HIVE-23230) HiveWarehouseConnector executeQuery api with query having "LIMIT" clause returns more rows
[ https://issues.apache.org/jira/browse/HIVE-23230?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan updated HIVE-23230: Affects Version/s: 3.1.0 > HiveWarehouseConnector executeQuery api with query having "LIMIT" clause > returns more rows > -- > > Key: HIVE-23230 > URL: https://issues.apache.org/jira/browse/HIVE-23230 > Project: Hive > Issue Type: Bug >Affects Versions: 3.1.0 >Reporter: Adesh Kumar Rao >Assignee: Adesh Kumar Rao >Priority: Major > Attachments: HIVE-23230.patch > > > The issue is reproducible when number of llap daemons is greater than 1. > > How to reproduce: > run below commands via beeline to create and populate the table > > {noformat} > create table test (id int); > insert into table test values (1); > insert into table test values (2); > insert into table test values (3); > insert into table test values (4); > insert into table test values (5); > insert into table test values (6); > insert into table test values (7); > delete from test where id = 7;{noformat} > now running below query via spark-shell > {noformat} > import com.hortonworks.hwc.HiveWarehouseSession > val hive = HiveWarehouseSession.session(spark).build() > hive.executeQuery("select * from test limit 1").show(){noformat} > will return more than 1 rows. -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Updated] (HIVE-23230) HiveWarehouseConnector executeQuery api with query having "LIMIT" clause returns more rows
[ https://issues.apache.org/jira/browse/HIVE-23230?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Adesh Kumar Rao updated HIVE-23230: --- Assignee: Adesh Kumar Rao Status: Patch Available (was: Open) First patch. Force generating a single split for queries containing limit, so that only a single llap daemons works on it, and limit clause is honored. Also, this change is behind a config which is by-default enabled. > HiveWarehouseConnector executeQuery api with query having "LIMIT" clause > returns more rows > -- > > Key: HIVE-23230 > URL: https://issues.apache.org/jira/browse/HIVE-23230 > Project: Hive > Issue Type: Bug >Reporter: Adesh Kumar Rao >Assignee: Adesh Kumar Rao >Priority: Major > Attachments: HIVE-23230.patch > > > The issue is reproducible when number of llap daemons is greater than 1. > > How to reproduce: > run below commands via beeline to create and populate the table > > {noformat} > create table test (id int); > insert into table test values (1); > insert into table test values (2); > insert into table test values (3); > insert into table test values (4); > insert into table test values (5); > insert into table test values (6); > insert into table test values (7); > delete from test where id = 7;{noformat} > now running below query via spark-shell > {noformat} > import com.hortonworks.hwc.HiveWarehouseSession > val hive = HiveWarehouseSession.session(spark).build() > hive.executeQuery("select * from test limit 1").show(){noformat} > will return more than 1 rows. -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Updated] (HIVE-23230) HiveWarehouseConnector executeQuery api with query having "LIMIT" clause returns more rows
[ https://issues.apache.org/jira/browse/HIVE-23230?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Adesh Kumar Rao updated HIVE-23230: --- Attachment: HIVE-23230.patch > HiveWarehouseConnector executeQuery api with query having "LIMIT" clause > returns more rows > -- > > Key: HIVE-23230 > URL: https://issues.apache.org/jira/browse/HIVE-23230 > Project: Hive > Issue Type: Bug >Reporter: Adesh Kumar Rao >Priority: Major > Attachments: HIVE-23230.patch > > > The issue is reproducible when number of llap daemons is greater than 1. > > How to reproduce: > run below commands via beeline to create and populate the table > > {noformat} > create table test (id int); > insert into table test values (1); > insert into table test values (2); > insert into table test values (3); > insert into table test values (4); > insert into table test values (5); > insert into table test values (6); > insert into table test values (7); > delete from test where id = 7;{noformat} > now running below query via spark-shell > {noformat} > import com.hortonworks.hwc.HiveWarehouseSession > val hive = HiveWarehouseSession.session(spark).build() > hive.executeQuery("select * from test limit 1").show(){noformat} > will return more than 1 rows. -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Updated] (HIVE-23230) HiveWarehouseConnector executeQuery api with query having "LIMIT" clause returns more rows
[ https://issues.apache.org/jira/browse/HIVE-23230?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Adesh Kumar Rao updated HIVE-23230: --- Description: The issue is reproducible when number of llap daemons is greater than 1. How to reproduce: run below commands via beeline to create and populate the table {noformat} create table test (id int); insert into table test values (1); insert into table test values (2); insert into table test values (3); insert into table test values (4); insert into table test values (5); insert into table test values (6); insert into table test values (7); delete from test where id = 7;{noformat} now running below query via spark-shell {noformat} import com.hortonworks.hwc.HiveWarehouseSession val hive = HiveWarehouseSession.session(spark).build() hive.executeQuery("select * from test limit 1").show(){noformat} will return more than 1 rows. was: The issue is reproducible when number of llap daemons is greater than 1. How to reproduce: ``` create table test (id int); insert into table test values (1); insert into table test values (2); insert into table test values (3); insert into table test values (4); insert into table test values (5); insert into table test values (6); insert into table test values (7); delete from test where id = 7; ``` now running `select * from test limit 1;` will return more than 1 rows. > HiveWarehouseConnector executeQuery api with query having "LIMIT" clause > returns more rows > -- > > Key: HIVE-23230 > URL: https://issues.apache.org/jira/browse/HIVE-23230 > Project: Hive > Issue Type: Bug >Reporter: Adesh Kumar Rao >Priority: Major > > The issue is reproducible when number of llap daemons is greater than 1. > > How to reproduce: > run below commands via beeline to create and populate the table > > {noformat} > create table test (id int); > insert into table test values (1); > insert into table test values (2); > insert into table test values (3); > insert into table test values (4); > insert into table test values (5); > insert into table test values (6); > insert into table test values (7); > delete from test where id = 7;{noformat} > now running below query via spark-shell > {noformat} > import com.hortonworks.hwc.HiveWarehouseSession > val hive = HiveWarehouseSession.session(spark).build() > hive.executeQuery("select * from test limit 1").show(){noformat} > will return more than 1 rows. -- This message was sent by Atlassian Jira (v8.3.4#803005)