[jira] [Updated] (HIVE-7122) Storage format for create like table
[ https://issues.apache.org/jira/browse/HIVE-7122?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vasanth kumar RJ updated HIVE-7122: --- Attachment: HIVE-7122.1.patch Attached updated patch. Please review. Storage format for create like table Key: HIVE-7122 URL: https://issues.apache.org/jira/browse/HIVE-7122 Project: Hive Issue Type: New Feature Components: Query Processor Reporter: Vasanth kumar RJ Assignee: Vasanth kumar RJ Attachments: HIVE-7122.1.patch, HIVE-7122.patch Using create like table user can specify the table storage format. Example: create table table1 like table2 stored as ORC; -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HIVE-7122) Storage format for create like table
[ https://issues.apache.org/jira/browse/HIVE-7122?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14251751#comment-14251751 ] Vasanth kumar RJ commented on HIVE-7122: Hi [~Prabhu Joseph], sorry for late reply. In CTAS restriction says target table cannot be partitioned and external. Like table allows to create similar table and external as well. Storage format for create like table Key: HIVE-7122 URL: https://issues.apache.org/jira/browse/HIVE-7122 Project: Hive Issue Type: New Feature Components: Query Processor Reporter: Vasanth kumar RJ Assignee: Vasanth kumar RJ Attachments: HIVE-7122.patch Using create like table user can specify the table storage format. Example: create table table1 like table2 stored as ORC; -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HIVE-7122) Storage format for create like table
[ https://issues.apache.org/jira/browse/HIVE-7122?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14246305#comment-14246305 ] Vasanth kumar RJ commented on HIVE-7122: Hi [~ashutoshc], will this feature be useful? So that I can update the patch. Storage format for create like table Key: HIVE-7122 URL: https://issues.apache.org/jira/browse/HIVE-7122 Project: Hive Issue Type: New Feature Components: Query Processor Reporter: Vasanth kumar RJ Assignee: Vasanth kumar RJ Attachments: HIVE-7122.patch Using create like table user can specify the table storage format. Example: create table table1 like table2 stored as ORC; -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HIVE-7695) hive stats issue when insert query is appending data into table
[
https://issues.apache.org/jira/browse/HIVE-7695?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14156112#comment-14156112
]
Vasanth kumar RJ commented on HIVE-7695:
+1
hive stats issue when insert query is appending data into table
---
Key: HIVE-7695
URL: https://issues.apache.org/jira/browse/HIVE-7695
Project: Hive
Issue Type: Bug
Components: Logical Optimizer, Statistics
Affects Versions: 0.13.0, 0.13.1
Reporter: Thejas M Nair
Assignee: Ashutosh Chauhan
Attachments: HIVE-7695-test.patch, HIVE-7695.1.patch,
HIVE-7695.2.patch, HIVE-7695.3.patch, HIVE-7695.4.patch, tests.patch
When 'insert' is used to append (not overrite), the stats don't seem to get
updated.
{code}
set hive.compute.query.using.stats=true;
set hive.stats.autogather=true;
//insert 4 rows
insert into table t2 select * from t1;
select count(*) from t2;
4
//insert 4 again (appending instead of overrite)
insert into table t2 select * from t1;
select count(*) from t2;
4
select * from t2;
1
2
3
4
1
2
3
4
{code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Updated] (HIVE-7695) hive stats issue when insert query is appending data into table
[
https://issues.apache.org/jira/browse/HIVE-7695?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Vasanth kumar RJ updated HIVE-7695:
---
Attachment: HIVE-7695-test.patch
[~thejas] attached test patch. update the stats while inserting. kindly check.
hive stats issue when insert query is appending data into table
---
Key: HIVE-7695
URL: https://issues.apache.org/jira/browse/HIVE-7695
Project: Hive
Issue Type: Bug
Components: Statistics
Affects Versions: 0.13.0, 0.13.1
Reporter: Thejas M Nair
Attachments: HIVE-7695-test.patch
When 'insert' is used to append (not overrite), the stats don't seem to get
updated.
{code}
set hive.compute.query.using.stats=true;
set hive.stats.autogather=true;
//insert 4 rows
insert into table t2 select * from t1;
select count(*) from t2;
4
//insert 4 again (appending instead of overrite)
insert into table t2 select * from t1;
select count(*) from t2;
4
select * from t2;
1
2
3
4
1
2
3
4
{code}
--
This message was sent by Atlassian JIRA
(v6.2#6252)
[jira] [Assigned] (HIVE-7403) stats are not updated correctly after doing insert into table
[ https://issues.apache.org/jira/browse/HIVE-7403?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vasanth kumar RJ reassigned HIVE-7403: -- Assignee: Vasanth kumar RJ stats are not updated correctly after doing insert into table - Key: HIVE-7403 URL: https://issues.apache.org/jira/browse/HIVE-7403 Project: Hive Issue Type: Bug Components: Statistics Affects Versions: 0.13.0, 0.13.1 Reporter: Ashutosh Chauhan Assignee: Vasanth kumar RJ Attachments: HIVE-7403.patch, testcase.patch This is follow-up of HIVE-7213 -- This message was sent by Atlassian JIRA (v6.2#6252)
[jira] [Updated] (HIVE-7403) stats are not updated correctly after doing insert into table
[ https://issues.apache.org/jira/browse/HIVE-7403?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vasanth kumar RJ updated HIVE-7403: --- Attachment: HIVE-7403.patch stats are not updated correctly after doing insert into table - Key: HIVE-7403 URL: https://issues.apache.org/jira/browse/HIVE-7403 Project: Hive Issue Type: Bug Components: Statistics Affects Versions: 0.13.0, 0.13.1 Reporter: Ashutosh Chauhan Attachments: HIVE-7403.patch, testcase.patch This is follow-up of HIVE-7213 -- This message was sent by Atlassian JIRA (v6.2#6252)
[jira] [Updated] (HIVE-7403) stats are not updated correctly after doing insert into table
[ https://issues.apache.org/jira/browse/HIVE-7403?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vasanth kumar RJ updated HIVE-7403: --- Status: Patch Available (was: Open) stats are not updated correctly after doing insert into table - Key: HIVE-7403 URL: https://issues.apache.org/jira/browse/HIVE-7403 Project: Hive Issue Type: Bug Components: Statistics Affects Versions: 0.13.1, 0.13.0 Reporter: Ashutosh Chauhan Assignee: Vasanth kumar RJ Attachments: HIVE-7403.patch, testcase.patch This is follow-up of HIVE-7213 -- This message was sent by Atlassian JIRA (v6.2#6252)
[jira] [Created] (HIVE-7199) Cannot alter table to parquet
Vasanth kumar RJ created HIVE-7199: -- Summary: Cannot alter table to parquet Key: HIVE-7199 URL: https://issues.apache.org/jira/browse/HIVE-7199 Project: Hive Issue Type: Bug Components: Query Processor Affects Versions: 0.13.1, 0.14.0 Reporter: Vasanth kumar RJ Assignee: Vasanth kumar RJ Cannot able to alter a table to parquet. alter table t1 set fileformat parquet; Then cannot able to query to the table. -- This message was sent by Atlassian JIRA (v6.2#6252)
[jira] [Updated] (HIVE-7199) Cannot alter table to parquet
[ https://issues.apache.org/jira/browse/HIVE-7199?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vasanth kumar RJ updated HIVE-7199: --- Attachment: HIVE-7199.patch Cannot alter table to parquet - Key: HIVE-7199 URL: https://issues.apache.org/jira/browse/HIVE-7199 Project: Hive Issue Type: Bug Components: Query Processor Affects Versions: 0.14.0, 0.13.1 Reporter: Vasanth kumar RJ Assignee: Vasanth kumar RJ Attachments: HIVE-7199.patch Cannot able to alter a table to parquet. alter table t1 set fileformat parquet; Then cannot able to query to the table. -- This message was sent by Atlassian JIRA (v6.2#6252)
[jira] [Updated] (HIVE-7199) Cannot alter table to parquet
[ https://issues.apache.org/jira/browse/HIVE-7199?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vasanth kumar RJ updated HIVE-7199: --- Fix Version/s: 0.14.0 Status: Patch Available (was: Open) Cannot alter table to parquet - Key: HIVE-7199 URL: https://issues.apache.org/jira/browse/HIVE-7199 Project: Hive Issue Type: Bug Components: Query Processor Affects Versions: 0.13.1, 0.14.0 Reporter: Vasanth kumar RJ Assignee: Vasanth kumar RJ Fix For: 0.14.0 Attachments: HIVE-7199.patch Cannot able to alter a table to parquet. alter table t1 set fileformat parquet; Then cannot able to query to the table. -- This message was sent by Atlassian JIRA (v6.2#6252)
[jira] [Commented] (HIVE-7071) Use custom Tez split generator to support schema evolution
[ https://issues.apache.org/jira/browse/HIVE-7071?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14015057#comment-14015057 ] Vasanth kumar RJ commented on HIVE-7071: Getting compile error when running maven for hadoop-1 Use custom Tez split generator to support schema evolution -- Key: HIVE-7071 URL: https://issues.apache.org/jira/browse/HIVE-7071 Project: Hive Issue Type: Bug Reporter: Gunther Hagleitner Assignee: Gunther Hagleitner Fix For: 0.14.0 Attachments: HIVE-7071.1.patch, HIVE-7071.2.patch Right now we're falling back to combinehivefileinputformat and switch of am side grouping when there's different schemata in a single vertex. We need to handle this in a custom initializer so we can still group on the AM. -- This message was sent by Atlassian JIRA (v6.2#6252)
[jira] [Created] (HIVE-7122) Storage format for create like table
Vasanth kumar RJ created HIVE-7122: -- Summary: Storage format for create like table Key: HIVE-7122 URL: https://issues.apache.org/jira/browse/HIVE-7122 Project: Hive Issue Type: New Feature Components: Query Processor Reporter: Vasanth kumar RJ Fix For: 0.14.0 Using create like table user can specify the table storage format. Example: create table table1 like table2 stored as ORC; -- This message was sent by Atlassian JIRA (v6.2#6252)
[jira] [Updated] (HIVE-7122) Storage format for create like table
[ https://issues.apache.org/jira/browse/HIVE-7122?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vasanth kumar RJ updated HIVE-7122: --- Attachment: HIVE-7122.patch Storage format for create like table Key: HIVE-7122 URL: https://issues.apache.org/jira/browse/HIVE-7122 Project: Hive Issue Type: New Feature Components: Query Processor Reporter: Vasanth kumar RJ Fix For: 0.14.0 Attachments: HIVE-7122.patch Using create like table user can specify the table storage format. Example: create table table1 like table2 stored as ORC; -- This message was sent by Atlassian JIRA (v6.2#6252)
[jira] [Commented] (HIVE-7122) Storage format for create like table
[ https://issues.apache.org/jira/browse/HIVE-7122?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14008164#comment-14008164 ] Vasanth kumar RJ commented on HIVE-7122: Sorry I am able to assign JIRA myself. Can anyone assign to me? Storage format for create like table Key: HIVE-7122 URL: https://issues.apache.org/jira/browse/HIVE-7122 Project: Hive Issue Type: New Feature Components: Query Processor Reporter: Vasanth kumar RJ Fix For: 0.14.0 Attachments: HIVE-7122.patch Using create like table user can specify the table storage format. Example: create table table1 like table2 stored as ORC; -- This message was sent by Atlassian JIRA (v6.2#6252)
[jira] [Commented] (HIVE-7122) Storage format for create like table
[ https://issues.apache.org/jira/browse/HIVE-7122?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14008163#comment-14008163 ] Vasanth kumar RJ commented on HIVE-7122: I am able to assign JIRA myself. Can anyone assign to me? Storage format for create like table Key: HIVE-7122 URL: https://issues.apache.org/jira/browse/HIVE-7122 Project: Hive Issue Type: New Feature Components: Query Processor Reporter: Vasanth kumar RJ Fix For: 0.14.0 Attachments: HIVE-7122.patch Using create like table user can specify the table storage format. Example: create table table1 like table2 stored as ORC; -- This message was sent by Atlassian JIRA (v6.2#6252)
[jira] [Updated] (HIVE-7122) Storage format for create like table
[ https://issues.apache.org/jira/browse/HIVE-7122?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vasanth kumar RJ updated HIVE-7122: --- Status: Patch Available (was: Open) Storage format for create like table Key: HIVE-7122 URL: https://issues.apache.org/jira/browse/HIVE-7122 Project: Hive Issue Type: New Feature Components: Query Processor Reporter: Vasanth kumar RJ Fix For: 0.14.0 Attachments: HIVE-7122.patch Using create like table user can specify the table storage format. Example: create table table1 like table2 stored as ORC; -- This message was sent by Atlassian JIRA (v6.2#6252)
[jira] [Updated] (HIVE-6756) alter table set fileformat should set serde too
[ https://issues.apache.org/jira/browse/HIVE-6756?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vasanth kumar RJ updated HIVE-6756: --- Attachment: HIVE-6756.1.patch alter table set fileformat should set serde too --- Key: HIVE-6756 URL: https://issues.apache.org/jira/browse/HIVE-6756 Project: Hive Issue Type: Bug Reporter: Owen O'Malley Assignee: Chinna Rao Lalam Attachments: HIVE-6756.1.patch, HIVE-6756.patch Currently doing alter table set fileformat doesn't change the serde. This is unexpected by customers because the serdes are largely file format specific. -- This message was sent by Atlassian JIRA (v6.2#6252)
[jira] [Commented] (HIVE-6756) alter table set fileformat should set serde too
[ https://issues.apache.org/jira/browse/HIVE-6756?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14000725#comment-14000725 ] Vasanth kumar RJ commented on HIVE-6756: Hi [~ashutoshc], Implemented as per your suggestion. Sorry [~chinnalalam] for taking over this JIRA. Kindly verify. Thanks, Vasanth kumar alter table set fileformat should set serde too --- Key: HIVE-6756 URL: https://issues.apache.org/jira/browse/HIVE-6756 Project: Hive Issue Type: Bug Reporter: Owen O'Malley Assignee: Chinna Rao Lalam Attachments: HIVE-6756.1.patch, HIVE-6756.patch Currently doing alter table set fileformat doesn't change the serde. This is unexpected by customers because the serdes are largely file format specific. -- This message was sent by Atlassian JIRA (v6.2#6252)
[jira] [Updated] (HIVE-6756) alter table set fileformat should set serde too
[ https://issues.apache.org/jira/browse/HIVE-6756?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vasanth kumar RJ updated HIVE-6756: --- Affects Version/s: 0.13.0 Status: Patch Available (was: Open) alter table set fileformat should set serde too --- Key: HIVE-6756 URL: https://issues.apache.org/jira/browse/HIVE-6756 Project: Hive Issue Type: Bug Affects Versions: 0.13.0 Reporter: Owen O'Malley Assignee: Chinna Rao Lalam Attachments: HIVE-6756.1.patch, HIVE-6756.patch Currently doing alter table set fileformat doesn't change the serde. This is unexpected by customers because the serdes are largely file format specific. -- This message was sent by Atlassian JIRA (v6.2#6252)
