[jira] [Updated] (HIVE-13422) Analyse command not working for column having datatype as decimal(38,0)
[ https://issues.apache.org/jira/browse/HIVE-13422?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Thomas Friedrich updated HIVE-13422: Attachment: HIVE-13422.patch > Analyse command not working for column having datatype as decimal(38,0) > --- > > Key: HIVE-13422 > URL: https://issues.apache.org/jira/browse/HIVE-13422 > Project: Hive > Issue Type: Bug > Components: Hive, Statistics >Affects Versions: 1.1.0 >Reporter: ashim sinha >Assignee: Thomas Friedrich > Attachments: HIVE-13422.patch > > > For the repro > {code} > drop table sample_test; > CREATE TABLE IF NOT EXISTS sample_test( key decimal(38,0),b int ) ROW FORMAT > DELIMITED FIELDS TERMINATED BY ',' STORED AS TEXTFILE; > load data local inpath '/home/hive/analyse.txt' into table sample_test; > ANALYZE TABLE sample_test COMPUTE STATISTICS FOR COLUMNS; > {code} > Sample data > {code} > 2023456789456749825082498304 0 > 5032080754887849825069508304 0 > 4012080754887849825068718304 0 > 2012080754887849825066778304 0 > 4012080754887849625065678304 0 > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HIVE-13422) Analyse command not working for column having datatype as decimal(38,0)
[ https://issues.apache.org/jira/browse/HIVE-13422?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Thomas Friedrich updated HIVE-13422: Status: Patch Available (was: Open) > Analyse command not working for column having datatype as decimal(38,0) > --- > > Key: HIVE-13422 > URL: https://issues.apache.org/jira/browse/HIVE-13422 > Project: Hive > Issue Type: Bug > Components: Hive, Statistics >Affects Versions: 1.1.0 >Reporter: ashim sinha >Assignee: Thomas Friedrich > Attachments: HIVE-13422.patch > > > For the repro > {code} > drop table sample_test; > CREATE TABLE IF NOT EXISTS sample_test( key decimal(38,0),b int ) ROW FORMAT > DELIMITED FIELDS TERMINATED BY ',' STORED AS TEXTFILE; > load data local inpath '/home/hive/analyse.txt' into table sample_test; > ANALYZE TABLE sample_test COMPUTE STATISTICS FOR COLUMNS; > {code} > Sample data > {code} > 2023456789456749825082498304 0 > 5032080754887849825069508304 0 > 4012080754887849825068718304 0 > 2012080754887849825066778304 0 > 4012080754887849625065678304 0 > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HIVE-13422) Analyse command not working for column having datatype as decimal(38,0)
[ https://issues.apache.org/jira/browse/HIVE-13422?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Thomas Friedrich updated HIVE-13422: Status: Patch Available (was: Open) > Analyse command not working for column having datatype as decimal(38,0) > --- > > Key: HIVE-13422 > URL: https://issues.apache.org/jira/browse/HIVE-13422 > Project: Hive > Issue Type: Bug > Components: Hive, Statistics >Affects Versions: 1.1.0 >Reporter: ashim sinha >Assignee: Thomas Friedrich > Attachments: HIVE-13422.patch > > > For the repro > {code} > drop table sample_test; > CREATE TABLE IF NOT EXISTS sample_test( key decimal(38,0),b int ) ROW FORMAT > DELIMITED FIELDS TERMINATED BY ',' STORED AS TEXTFILE; > load data local inpath '/home/hive/analyse.txt' into table sample_test; > ANALYZE TABLE sample_test COMPUTE STATISTICS FOR COLUMNS; > {code} > Sample data > {code} > 2023456789456749825082498304 0 > 5032080754887849825069508304 0 > 4012080754887849825068718304 0 > 2012080754887849825066778304 0 > 4012080754887849625065678304 0 > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HIVE-13422) Analyse command not working for column having datatype as decimal(38,0)
[ https://issues.apache.org/jira/browse/HIVE-13422?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Thomas Friedrich updated HIVE-13422: Status: Open (was: Patch Available) > Analyse command not working for column having datatype as decimal(38,0) > --- > > Key: HIVE-13422 > URL: https://issues.apache.org/jira/browse/HIVE-13422 > Project: Hive > Issue Type: Bug > Components: Hive, Statistics >Affects Versions: 1.1.0 >Reporter: ashim sinha >Assignee: Thomas Friedrich > Attachments: HIVE-13422.patch > > > For the repro > {code} > drop table sample_test; > CREATE TABLE IF NOT EXISTS sample_test( key decimal(38,0),b int ) ROW FORMAT > DELIMITED FIELDS TERMINATED BY ',' STORED AS TEXTFILE; > load data local inpath '/home/hive/analyse.txt' into table sample_test; > ANALYZE TABLE sample_test COMPUTE STATISTICS FOR COLUMNS; > {code} > Sample data > {code} > 2023456789456749825082498304 0 > 5032080754887849825069508304 0 > 4012080754887849825068718304 0 > 2012080754887849825066778304 0 > 4012080754887849625065678304 0 > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HIVE-13422) Analyse command not working for column having datatype as decimal(38,0)
[ https://issues.apache.org/jira/browse/HIVE-13422?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashutosh Chauhan updated HIVE-13422: Resolution: Fixed Fix Version/s: 2.2.0 Status: Resolved (was: Patch Available) Pushed to master. Thanks, Thomas! > Analyse command not working for column having datatype as decimal(38,0) > --- > > Key: HIVE-13422 > URL: https://issues.apache.org/jira/browse/HIVE-13422 > Project: Hive > Issue Type: Bug > Components: Hive, Statistics >Affects Versions: 1.1.0 >Reporter: ashim sinha >Assignee: Thomas Friedrich > Fix For: 2.2.0 > > Attachments: HIVE-13422.patch > > > For the repro > {code} > drop table sample_test; > CREATE TABLE IF NOT EXISTS sample_test( key decimal(38,0),b int ) ROW FORMAT > DELIMITED FIELDS TERMINATED BY ',' STORED AS TEXTFILE; > load data local inpath '/home/hive/analyse.txt' into table sample_test; > ANALYZE TABLE sample_test COMPUTE STATISTICS FOR COLUMNS; > {code} > Sample data > {code} > 2023456789456749825082498304 0 > 5032080754887849825069508304 0 > 4012080754887849825068718304 0 > 2012080754887849825066778304 0 > 4012080754887849625065678304 0 > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HIVE-13422) Analyse command not working for column having datatype as decimal(38,0)
[ https://issues.apache.org/jira/browse/HIVE-13422?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ashim sinha updated HIVE-13422: --- Description: Any update on this? > Analyse command not working for column having datatype as decimal(38,0) > --- > > Key: HIVE-13422 > URL: https://issues.apache.org/jira/browse/HIVE-13422 > Project: Hive > Issue Type: Bug > Components: Hive, Statistics >Affects Versions: 1.1.0 >Reporter: ashim sinha > > Any update on this? -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HIVE-13422) Analyse command not working for column having datatype as decimal(38,0)
[ https://issues.apache.org/jira/browse/HIVE-13422?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Xuefu Zhang updated HIVE-13422: --- Description: For the repro drop table sample_test; CREATE TABLE IF NOT EXISTS sample_test( key decimal(38,0),b int ) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' STORED AS TEXTFILE; load data local inpath '/home/hive/analyse.txt' into table sample_test; ANALYZE TABLE sample_test COMPUTE STATISTICS FOR COLUMNS; Sample data 2023456789456749825082498304 0 5032080754887849825069508304 0 4012080754887849825068718304 0 2012080754887849825066778304 0 4012080754887849625065678304 0 was:Any update on this? > Analyse command not working for column having datatype as decimal(38,0) > --- > > Key: HIVE-13422 > URL: https://issues.apache.org/jira/browse/HIVE-13422 > Project: Hive > Issue Type: Bug > Components: Hive, Statistics >Affects Versions: 1.1.0 >Reporter: ashim sinha > > For the repro > drop table sample_test; > CREATE TABLE IF NOT EXISTS sample_test( key decimal(38,0),b int ) ROW FORMAT > DELIMITED FIELDS TERMINATED BY ',' STORED AS TEXTFILE; > load data local inpath '/home/hive/analyse.txt' into table sample_test; > ANALYZE TABLE sample_test COMPUTE STATISTICS FOR COLUMNS; > Sample data > 2023456789456749825082498304 0 > 5032080754887849825069508304 0 > 4012080754887849825068718304 0 > 2012080754887849825066778304 0 > 4012080754887849625065678304 0 -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HIVE-13422) Analyse command not working for column having datatype as decimal(38,0)
[ https://issues.apache.org/jira/browse/HIVE-13422?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Xuefu Zhang updated HIVE-13422: --- Description: For the repro {code} drop table sample_test; CREATE TABLE IF NOT EXISTS sample_test( key decimal(38,0),b int ) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' STORED AS TEXTFILE; load data local inpath '/home/hive/analyse.txt' into table sample_test; ANALYZE TABLE sample_test COMPUTE STATISTICS FOR COLUMNS; {code} Sample data {code} 2023456789456749825082498304 0 5032080754887849825069508304 0 4012080754887849825068718304 0 2012080754887849825066778304 0 4012080754887849625065678304 0 (code} was: For the repro drop table sample_test; CREATE TABLE IF NOT EXISTS sample_test( key decimal(38,0),b int ) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' STORED AS TEXTFILE; load data local inpath '/home/hive/analyse.txt' into table sample_test; ANALYZE TABLE sample_test COMPUTE STATISTICS FOR COLUMNS; Sample data 2023456789456749825082498304 0 5032080754887849825069508304 0 4012080754887849825068718304 0 2012080754887849825066778304 0 4012080754887849625065678304 0 > Analyse command not working for column having datatype as decimal(38,0) > --- > > Key: HIVE-13422 > URL: https://issues.apache.org/jira/browse/HIVE-13422 > Project: Hive > Issue Type: Bug > Components: Hive, Statistics >Affects Versions: 1.1.0 >Reporter: ashim sinha > > For the repro > {code} > drop table sample_test; > CREATE TABLE IF NOT EXISTS sample_test( key decimal(38,0),b int ) ROW FORMAT > DELIMITED FIELDS TERMINATED BY ',' STORED AS TEXTFILE; > load data local inpath '/home/hive/analyse.txt' into table sample_test; > ANALYZE TABLE sample_test COMPUTE STATISTICS FOR COLUMNS; > {code} > Sample data > {code} > 2023456789456749825082498304 0 > 5032080754887849825069508304 0 > 4012080754887849825068718304 0 > 2012080754887849825066778304 0 > 4012080754887849625065678304 0 > (code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HIVE-13422) Analyse command not working for column having datatype as decimal(38,0)
[ https://issues.apache.org/jira/browse/HIVE-13422?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Xuefu Zhang updated HIVE-13422: --- Description: For the repro {code} drop table sample_test; CREATE TABLE IF NOT EXISTS sample_test( key decimal(38,0),b int ) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' STORED AS TEXTFILE; load data local inpath '/home/hive/analyse.txt' into table sample_test; ANALYZE TABLE sample_test COMPUTE STATISTICS FOR COLUMNS; {code} Sample data {code} 2023456789456749825082498304 0 5032080754887849825069508304 0 4012080754887849825068718304 0 2012080754887849825066778304 0 4012080754887849625065678304 0 {code} was: For the repro {code} drop table sample_test; CREATE TABLE IF NOT EXISTS sample_test( key decimal(38,0),b int ) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' STORED AS TEXTFILE; load data local inpath '/home/hive/analyse.txt' into table sample_test; ANALYZE TABLE sample_test COMPUTE STATISTICS FOR COLUMNS; {code} Sample data {code} 2023456789456749825082498304 0 5032080754887849825069508304 0 4012080754887849825068718304 0 2012080754887849825066778304 0 4012080754887849625065678304 0 (code} > Analyse command not working for column having datatype as decimal(38,0) > --- > > Key: HIVE-13422 > URL: https://issues.apache.org/jira/browse/HIVE-13422 > Project: Hive > Issue Type: Bug > Components: Hive, Statistics >Affects Versions: 1.1.0 >Reporter: ashim sinha > > For the repro > {code} > drop table sample_test; > CREATE TABLE IF NOT EXISTS sample_test( key decimal(38,0),b int ) ROW FORMAT > DELIMITED FIELDS TERMINATED BY ',' STORED AS TEXTFILE; > load data local inpath '/home/hive/analyse.txt' into table sample_test; > ANALYZE TABLE sample_test COMPUTE STATISTICS FOR COLUMNS; > {code} > Sample data > {code} > 2023456789456749825082498304 0 > 5032080754887849825069508304 0 > 4012080754887849825068718304 0 > 2012080754887849825066778304 0 > 4012080754887849625065678304 0 > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)