[jira] [Commented] (HIVE-11149) Fix issue with sometimes HashMap in PerfLogger.java hangs

[NING DING (JIRA)]

[ 
https://issues.apache.org/jira/browse/HIVE-11149?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14950121#comment-14950121
 ] 

NING DING commented on HIVE-11149:
--

Could anyone put this patch to branch-1.2, thanks.

> Fix issue with sometimes HashMap in PerfLogger.java hangs 
> --
>
> Key: HIVE-11149
> URL: https://issues.apache.org/jira/browse/HIVE-11149
> Project: Hive
>  Issue Type: Bug
>  Components: Logging
>Affects Versions: 1.2.1
>Reporter: WangMeng
>Assignee: WangMeng
> Fix For: 2.0.0
>
> Attachments: HIVE-11149.01.patch, HIVE-11149.02.patch, 
> HIVE-11149.03.patch, HIVE-11149.04.patch
>
>
> In  Multi-thread environment,  sometimes the  HashMap in PerfLogger.java  
> will  casue massive Java Processes hang  and cost  large amounts of 
> unnecessary CPU and Memory.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Commented] (HIVE-11931) Join sql cannot get result

[NING DING (JIRA)]

[ 
https://issues.apache.org/jira/browse/HIVE-11931?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14906216#comment-14906216
 ] 

NING DING commented on HIVE-11931:
--

[~namit] would you kindly help to take a look on this issue?
Thanks a lot.

> Join sql cannot get result
> --
>
> Key: HIVE-11931
> URL: https://issues.apache.org/jira/browse/HIVE-11931
> Project: Hive
>  Issue Type: Bug
>  Components: Hive, Query Planning, Query Processor, SQL
>Affects Versions: 1.1.1, 1.2.1
>Reporter: NING DING
> Attachments: 00_0
>
>
> I found a join issue in hive-1.2.1 and hive-1.1.1.
> The create table sql is as below.
> {code}
> CREATE TABLE IF NOT EXISTS join_case(
> orderid  bigint,
> tradeitemid bigint,
> id bigint
> ) ROW FORMAT DELIMITED
> FIELDS TERMINATED BY ',' 
> LINES TERMINATED BY '\n'
> STORED AS TEXTFILE;
> {code}
> Please put attached sample data file 00_0 in /tmp/join_case folder.
> Then load data.
> {code}
> LOAD DATA LOCAL INPATH '/tmp/join_case/00_0' OVERWRITE INTO TABLE 
> join_case;
> {code}
> Run the following sql, but cannot get searching result.
> {code}
> select a.id from 
> (
> select orderid as orderid, max(id) as id from join_case group by orderid
> ) a 
> join 
> (
> select id as id , orderid as orderid from join_case
> ) b
> on a.id = b.id limit 10;
> {code}
> This issue also occurs in hive-1.1.0-cdh5.4.5.
> But in apache hive-1.0.1 the above sql can return 10 rows.
> After exchanging the sequence of "orderid as orderid" and "max(id) as id", 
> the following sql can get result in hive-1.2.1 and hive-1.1.1.
> {code}
> select a.id from 
> (
> select max(id) as id, orderid as orderid from join_case group by orderid
> ) a 
> join 
> (
> select id as id , orderid as orderid from join_case
> ) b
> on a.id = b.id limit 10;
> {code}
> Also, the following sql can get results in hive-1.2.1 and hive-1.1.1.
> {code}
> select a.id from 
> (
> select orderid as orderid, id as id from join_case group by orderid, id
> ) a 
> join 
> (
> select id as id , orderid as orderid from join_case
> ) b
> on a.id = b.id limit 10; 
> {code}
> Anyone can take a look at this issue? 
> Thanks.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Updated] (HIVE-11931) Join sql cannot get result

[NING DING (JIRA)]

 [ 
https://issues.apache.org/jira/browse/HIVE-11931?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

NING DING updated HIVE-11931:
-
Affects Version/s: 1.1.1
   1.2.1
  Description: 
I found a join issue in hive-1.2.1 and hive-1.1.1.
The create table sql is as below.
{code}
CREATE TABLE IF NOT EXISTS join_case(
orderid  bigint,
tradeitemid bigint,
id bigint
) ROW FORMAT DELIMITED
FIELDS TERMINATED BY ',' 
LINES TERMINATED BY '\n'
STORED AS TEXTFILE;
{code}
Please put attached sample data file 00_0 in /tmp/join_case folder.
Then load data.
{code}
LOAD DATA LOCAL INPATH '/tmp/join_case/00_0' OVERWRITE INTO TABLE join_case;
{code}
Run the following sql, but cannot get searching result.
{code}
select a.id from 
(
select orderid as orderid, max(id) as id from join_case group by orderid
) a 
join 
(
select id as id , orderid as orderid from join_case
) b
on a.id = b.id limit 10;
{code}
This issue also occurs in hive-1.1.0-cdh5.4.5.
But in apache hive-1.0.1 the above sql can return 10 rows.

After exchanging the sequence of "orderid as orderid" and "max(id) as id", the 
following sql can get result in hive-1.2.1 and hive-1.1.1.
{code}
select a.id from 
(
select max(id) as id, orderid as orderid from join_case group by orderid
) a 
join 
(
select id as id , orderid as orderid from join_case
) b
on a.id = b.id limit 10;
{code}
Also, the following sql can get results in hive-1.2.1 and hive-1.1.1.
{code}
select a.id from 
(
select orderid as orderid, id as id from join_case group by orderid, id
) a 
join 
(
select id as id , orderid as orderid from join_case
) b
on a.id = b.id limit 10; 
{code}
Anyone can take a look at this issue? 
Thanks.
  Component/s: SQL
   Query Processor
   Query Planning
   Hive

> Join sql cannot get result
> --
>
> Key: HIVE-11931
> URL: https://issues.apache.org/jira/browse/HIVE-11931
> Project: Hive
>  Issue Type: Bug
>  Components: Hive, Query Planning, Query Processor, SQL
>Affects Versions: 1.1.1, 1.2.1
>Reporter: NING DING
>
> I found a join issue in hive-1.2.1 and hive-1.1.1.
> The create table sql is as below.
> {code}
> CREATE TABLE IF NOT EXISTS join_case(
> orderid  bigint,
> tradeitemid bigint,
> id bigint
> ) ROW FORMAT DELIMITED
> FIELDS TERMINATED BY ',' 
> LINES TERMINATED BY '\n'
> STORED AS TEXTFILE;
> {code}
> Please put attached sample data file 00_0 in /tmp/join_case folder.
> Then load data.
> {code}
> LOAD DATA LOCAL INPATH '/tmp/join_case/00_0' OVERWRITE INTO TABLE 
> join_case;
> {code}
> Run the following sql, but cannot get searching result.
> {code}
> select a.id from 
> (
> select orderid as orderid, max(id) as id from join_case group by orderid
> ) a 
> join 
> (
> select id as id , orderid as orderid from join_case
> ) b
> on a.id = b.id limit 10;
> {code}
> This issue also occurs in hive-1.1.0-cdh5.4.5.
> But in apache hive-1.0.1 the above sql can return 10 rows.
> After exchanging the sequence of "orderid as orderid" and "max(id) as id", 
> the following sql can get result in hive-1.2.1 and hive-1.1.1.
> {code}
> select a.id from 
> (
> select max(id) as id, orderid as orderid from join_case group by orderid
> ) a 
> join 
> (
> select id as id , orderid as orderid from join_case
> ) b
> on a.id = b.id limit 10;
> {code}
> Also, the following sql can get results in hive-1.2.1 and hive-1.1.1.
> {code}
> select a.id from 
> (
> select orderid as orderid, id as id from join_case group by orderid, id
> ) a 
> join 
> (
> select id as id , orderid as orderid from join_case
> ) b
> on a.id = b.id limit 10; 
> {code}
> Anyone can take a look at this issue? 
> Thanks.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Updated] (HIVE-11931) Join sql cannot get result

[NING DING (JIRA)]

 [ 
https://issues.apache.org/jira/browse/HIVE-11931?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

NING DING updated HIVE-11931:
-
Attachment: 00_0

sample data file

> Join sql cannot get result
> --
>
> Key: HIVE-11931
> URL: https://issues.apache.org/jira/browse/HIVE-11931
> Project: Hive
>  Issue Type: Bug
>  Components: Hive, Query Planning, Query Processor, SQL
>Affects Versions: 1.1.1, 1.2.1
>Reporter: NING DING
> Attachments: 00_0
>
>
> I found a join issue in hive-1.2.1 and hive-1.1.1.
> The create table sql is as below.
> {code}
> CREATE TABLE IF NOT EXISTS join_case(
> orderid  bigint,
> tradeitemid bigint,
> id bigint
> ) ROW FORMAT DELIMITED
> FIELDS TERMINATED BY ',' 
> LINES TERMINATED BY '\n'
> STORED AS TEXTFILE;
> {code}
> Please put attached sample data file 00_0 in /tmp/join_case folder.
> Then load data.
> {code}
> LOAD DATA LOCAL INPATH '/tmp/join_case/00_0' OVERWRITE INTO TABLE 
> join_case;
> {code}
> Run the following sql, but cannot get searching result.
> {code}
> select a.id from 
> (
> select orderid as orderid, max(id) as id from join_case group by orderid
> ) a 
> join 
> (
> select id as id , orderid as orderid from join_case
> ) b
> on a.id = b.id limit 10;
> {code}
> This issue also occurs in hive-1.1.0-cdh5.4.5.
> But in apache hive-1.0.1 the above sql can return 10 rows.
> After exchanging the sequence of "orderid as orderid" and "max(id) as id", 
> the following sql can get result in hive-1.2.1 and hive-1.1.1.
> {code}
> select a.id from 
> (
> select max(id) as id, orderid as orderid from join_case group by orderid
> ) a 
> join 
> (
> select id as id , orderid as orderid from join_case
> ) b
> on a.id = b.id limit 10;
> {code}
> Also, the following sql can get results in hive-1.2.1 and hive-1.1.1.
> {code}
> select a.id from 
> (
> select orderid as orderid, id as id from join_case group by orderid, id
> ) a 
> join 
> (
> select id as id , orderid as orderid from join_case
> ) b
> on a.id = b.id limit 10; 
> {code}
> Anyone can take a look at this issue? 
> Thanks.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)