[jira] [Commented] (HIVE-2906) Support providing some table properties by user via SQL
[
https://issues.apache.org/jira/browse/HIVE-2906?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14172104#comment-14172104
]
cw commented on HIVE-2906:
--
Hi [~navis]. We found that we can not use the identifier 'user' as table alias
because the FromClauseParser.g was changed in this patch.
-: tabname=tableName (ts=tableSample)? (KW_AS? alias=identifier)?
-- ^(TOK_TABREF $tabname $ts? $alias?)
+: tabname=tableName (props=tableProperties)? (ts=tableSample)? (KW_AS?
alias=Identifier)?
+- ^(TOK_TABREF $tabname $props? $ts? $alias?)
It changed the 'identifier' to a uppercase 'Identifier'. Is it intended or just
a mistake?
Support providing some table properties by user via SQL
---
Key: HIVE-2906
URL: https://issues.apache.org/jira/browse/HIVE-2906
Project: Hive
Issue Type: Improvement
Components: Query Processor
Reporter: Navis
Assignee: Navis
Fix For: 0.12.0
Attachments: ASF.LICENSE.NOT.GRANTED--HIVE-2906.D2499.1.patch,
ASF.LICENSE.NOT.GRANTED--HIVE-2906.D2499.2.patch,
ASF.LICENSE.NOT.GRANTED--HIVE-2906.D2499.3.patch,
ASF.LICENSE.NOT.GRANTED--HIVE-2906.D2499.4.patch,
ASF.LICENSE.NOT.GRANTED--HIVE-2906.D2499.5.patch, HIVE-2906.D2499.6.patch,
HIVE-2906.D2499.7.patch
Some properties are needed to be provided to StorageHandler by user in
runtime. It might be an address for remote resource or retry count for access
or maximum version count(for hbase), etc.
For example,
{code}
select emp.empno, emp.ename from hbase_emp ('max.version'='3') emp;
{code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Commented] (HIVE-2906) Support providing some table properties by user via SQL
[
https://issues.apache.org/jira/browse/HIVE-2906?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14172115#comment-14172115
]
Navis commented on HIVE-2906:
-
[~cwsteinbach] It seemed apparently a mistake. There was not identifier type
when this patch was first created (see the first patch). Seemed need a fix.
Would you do that or do I?
Support providing some table properties by user via SQL
---
Key: HIVE-2906
URL: https://issues.apache.org/jira/browse/HIVE-2906
Project: Hive
Issue Type: Improvement
Components: Query Processor
Reporter: Navis
Assignee: Navis
Fix For: 0.12.0
Attachments: ASF.LICENSE.NOT.GRANTED--HIVE-2906.D2499.1.patch,
ASF.LICENSE.NOT.GRANTED--HIVE-2906.D2499.2.patch,
ASF.LICENSE.NOT.GRANTED--HIVE-2906.D2499.3.patch,
ASF.LICENSE.NOT.GRANTED--HIVE-2906.D2499.4.patch,
ASF.LICENSE.NOT.GRANTED--HIVE-2906.D2499.5.patch, HIVE-2906.D2499.6.patch,
HIVE-2906.D2499.7.patch
Some properties are needed to be provided to StorageHandler by user in
runtime. It might be an address for remote resource or retry count for access
or maximum version count(for hbase), etc.
For example,
{code}
select emp.empno, emp.ename from hbase_emp ('max.version'='3') emp;
{code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Commented] (HIVE-2906) Support providing some table properties by user via SQL
[
https://issues.apache.org/jira/browse/HIVE-2906?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14172119#comment-14172119
]
cw commented on HIVE-2906:
--
[~navis] I would like to create a issue and submit a patch to fix it.
Support providing some table properties by user via SQL
---
Key: HIVE-2906
URL: https://issues.apache.org/jira/browse/HIVE-2906
Project: Hive
Issue Type: Improvement
Components: Query Processor
Reporter: Navis
Assignee: Navis
Fix For: 0.12.0
Attachments: ASF.LICENSE.NOT.GRANTED--HIVE-2906.D2499.1.patch,
ASF.LICENSE.NOT.GRANTED--HIVE-2906.D2499.2.patch,
ASF.LICENSE.NOT.GRANTED--HIVE-2906.D2499.3.patch,
ASF.LICENSE.NOT.GRANTED--HIVE-2906.D2499.4.patch,
ASF.LICENSE.NOT.GRANTED--HIVE-2906.D2499.5.patch, HIVE-2906.D2499.6.patch,
HIVE-2906.D2499.7.patch
Some properties are needed to be provided to StorageHandler by user in
runtime. It might be an address for remote resource or retry count for access
or maximum version count(for hbase), etc.
For example,
{code}
select emp.empno, emp.ename from hbase_emp ('max.version'='3') emp;
{code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Commented] (HIVE-2906) Support providing some table properties by user via SQL
[
https://issues.apache.org/jira/browse/HIVE-2906?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14172132#comment-14172132
]
cw commented on HIVE-2906:
--
[~navis] I created a issue here: https://issues.apache.org/jira/browse/HIVE-8466
Support providing some table properties by user via SQL
---
Key: HIVE-2906
URL: https://issues.apache.org/jira/browse/HIVE-2906
Project: Hive
Issue Type: Improvement
Components: Query Processor
Reporter: Navis
Assignee: Navis
Fix For: 0.12.0
Attachments: ASF.LICENSE.NOT.GRANTED--HIVE-2906.D2499.1.patch,
ASF.LICENSE.NOT.GRANTED--HIVE-2906.D2499.2.patch,
ASF.LICENSE.NOT.GRANTED--HIVE-2906.D2499.3.patch,
ASF.LICENSE.NOT.GRANTED--HIVE-2906.D2499.4.patch,
ASF.LICENSE.NOT.GRANTED--HIVE-2906.D2499.5.patch, HIVE-2906.D2499.6.patch,
HIVE-2906.D2499.7.patch
Some properties are needed to be provided to StorageHandler by user in
runtime. It might be an address for remote resource or retry count for access
or maximum version count(for hbase), etc.
For example,
{code}
select emp.empno, emp.ename from hbase_emp ('max.version'='3') emp;
{code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Commented] (HIVE-2906) Support providing some table properties by user via SQL
[
https://issues.apache.org/jira/browse/HIVE-2906?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14172135#comment-14172135
]
Navis commented on HIVE-2906:
-
[~cwsteinbach] Good. Thanks!
Support providing some table properties by user via SQL
---
Key: HIVE-2906
URL: https://issues.apache.org/jira/browse/HIVE-2906
Project: Hive
Issue Type: Improvement
Components: Query Processor
Reporter: Navis
Assignee: Navis
Fix For: 0.12.0
Attachments: ASF.LICENSE.NOT.GRANTED--HIVE-2906.D2499.1.patch,
ASF.LICENSE.NOT.GRANTED--HIVE-2906.D2499.2.patch,
ASF.LICENSE.NOT.GRANTED--HIVE-2906.D2499.3.patch,
ASF.LICENSE.NOT.GRANTED--HIVE-2906.D2499.4.patch,
ASF.LICENSE.NOT.GRANTED--HIVE-2906.D2499.5.patch, HIVE-2906.D2499.6.patch,
HIVE-2906.D2499.7.patch
Some properties are needed to be provided to StorageHandler by user in
runtime. It might be an address for remote resource or retry count for access
or maximum version count(for hbase), etc.
For example,
{code}
select emp.empno, emp.ename from hbase_emp ('max.version'='3') emp;
{code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Commented] (HIVE-2906) Support providing some table properties by user via SQL
[
https://issues.apache.org/jira/browse/HIVE-2906?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13722511#comment-13722511
]
Edward Capriolo commented on HIVE-2906:
---
Committed. Thanks Navis.
Support providing some table properties by user via SQL
---
Key: HIVE-2906
URL: https://issues.apache.org/jira/browse/HIVE-2906
Project: Hive
Issue Type: Improvement
Components: Query Processor
Reporter: Navis
Assignee: Navis
Attachments: ASF.LICENSE.NOT.GRANTED--HIVE-2906.D2499.1.patch,
ASF.LICENSE.NOT.GRANTED--HIVE-2906.D2499.2.patch,
ASF.LICENSE.NOT.GRANTED--HIVE-2906.D2499.3.patch,
ASF.LICENSE.NOT.GRANTED--HIVE-2906.D2499.4.patch,
ASF.LICENSE.NOT.GRANTED--HIVE-2906.D2499.5.patch, HIVE-2906.D2499.6.patch,
HIVE-2906.D2499.7.patch
Some properties are needed to be provided to StorageHandler by user in
runtime. It might be an address for remote resource or retry count for access
or maximum version count(for hbase), etc.
For example,
{code}
select emp.empno, emp.ename from hbase_emp ('max.version'='3') emp;
{code}
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (HIVE-2906) Support providing some table properties by user via SQL
[
https://issues.apache.org/jira/browse/HIVE-2906?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13721656#comment-13721656
]
Edward Capriolo commented on HIVE-2906:
---
+1. I think this is a very clean way to handle this. This opens up a lot of
different ways to use input formats and serde
Support providing some table properties by user via SQL
---
Key: HIVE-2906
URL: https://issues.apache.org/jira/browse/HIVE-2906
Project: Hive
Issue Type: Improvement
Components: Query Processor
Reporter: Navis
Assignee: Navis
Attachments: ASF.LICENSE.NOT.GRANTED--HIVE-2906.D2499.1.patch,
ASF.LICENSE.NOT.GRANTED--HIVE-2906.D2499.2.patch,
ASF.LICENSE.NOT.GRANTED--HIVE-2906.D2499.3.patch,
ASF.LICENSE.NOT.GRANTED--HIVE-2906.D2499.4.patch,
ASF.LICENSE.NOT.GRANTED--HIVE-2906.D2499.5.patch, HIVE-2906.D2499.6.patch,
HIVE-2906.D2499.7.patch
Some properties are needed to be provided to StorageHandler by user in
runtime. It might be an address for remote resource or retry count for access
or maximum version count(for hbase), etc.
For example,
{code}
select emp.empno, emp.ename from hbase_emp ('max.version'='3') emp;
{code}
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (HIVE-2906) Support providing some table properties by user via SQL
[
https://issues.apache.org/jira/browse/HIVE-2906?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13713621#comment-13713621
]
Hive QA commented on HIVE-2906:
---
{color:red}Overall{color}: -1 build exited with an error
Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12593110/HIVE-2906.D2499.6.patch
{color:red}ERROR:{color} -1 due to 4 failed/errored test(s)
Failed tests:
org.apache.hadoop.hive.ql.parse.TestParseNegative.testParseNegative_missing_overwrite
org.apache.hadoop.hive.cli.TestNegativeCliDriver.testNegativeCliDriver_ptf_negative_DistributeByOrderBy
org.apache.hadoop.hive.cli.TestNegativeCliDriver.testNegativeCliDriver_ptf_negative_PartitionBySortBy
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_input4
Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/91/testReport
Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/91/console
Messages:
Executing org.apache.hive.ptest.execution.CleanupPhase
Executing org.apache.hive.ptest.execution.PrepPhase
Executing org.apache.hive.ptest.execution.ExecutionPhase
Executing org.apache.hive.ptest.execution.ReportingPhase
Tests failed with: TestsFailedException: 4 tests failed
This message is automatically generated.
Support providing some table properties by user via SQL
---
Key: HIVE-2906
URL: https://issues.apache.org/jira/browse/HIVE-2906
Project: Hive
Issue Type: Improvement
Components: Query Processor
Reporter: Navis
Assignee: Navis
Attachments: ASF.LICENSE.NOT.GRANTED--HIVE-2906.D2499.1.patch,
ASF.LICENSE.NOT.GRANTED--HIVE-2906.D2499.2.patch,
ASF.LICENSE.NOT.GRANTED--HIVE-2906.D2499.3.patch,
ASF.LICENSE.NOT.GRANTED--HIVE-2906.D2499.4.patch,
ASF.LICENSE.NOT.GRANTED--HIVE-2906.D2499.5.patch, HIVE-2906.D2499.6.patch
Some properties are needed to be provided to StorageHandler by user in
runtime. It might be an address for remote resource or retry count for access
or maximum version count(for hbase), etc.
For example,
{code}
select emp.empno, emp.ename from hbase_emp ('max.version'='3') emp;
{code}
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
Re: [jira] [Commented] (HIVE-2906) Support providing some table properties by user via SQL
I will be looking at this soon.
On Friday, July 19, 2013, Hive QA (JIRA) j...@apache.org wrote:
[
https://issues.apache.org/jira/browse/HIVE-2906?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13713621#comment-13713621]
Hive QA commented on HIVE-2906:
---
{color:red}Overall{color}: -1 build exited with an error
Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12593110/HIVE-2906.D2499.6.patch
{color:red}ERROR:{color} -1 due to 4 failed/errored test(s)
Failed tests:
org.apache.hadoop.hive.ql.parse.TestParseNegative.testParseNegative_missing_overwrite
org.apache.hadoop.hive.cli.TestNegativeCliDriver.testNegativeCliDriver_ptf_negative_DistributeByOrderBy
org.apache.hadoop.hive.cli.TestNegativeCliDriver.testNegativeCliDriver_ptf_negative_PartitionBySortBy
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_input4
Test results:
https://builds.apache.org/job/PreCommit-HIVE-Build/91/testReport
Console output:
https://builds.apache.org/job/PreCommit-HIVE-Build/91/console
Messages:
Executing org.apache.hive.ptest.execution.CleanupPhase
Executing org.apache.hive.ptest.execution.PrepPhase
Executing org.apache.hive.ptest.execution.ExecutionPhase
Executing org.apache.hive.ptest.execution.ReportingPhase
Tests failed with: TestsFailedException: 4 tests failed
This message is automatically generated.
Support providing some table properties by user via SQL
---
Key: HIVE-2906
URL: https://issues.apache.org/jira/browse/HIVE-2906
Project: Hive
Issue Type: Improvement
Components: Query Processor
Reporter: Navis
Assignee: Navis
Attachments: ASF.LICENSE.NOT.GRANTED--HIVE-2906.D2499.1.patch,
ASF.LICENSE.NOT.GRANTED--HIVE-2906.D2499.2.patch,
ASF.LICENSE.NOT.GRANTED--HIVE-2906.D2499.3.patch,
ASF.LICENSE.NOT.GRANTED--HIVE-2906.D2499.4.patch,
ASF.LICENSE.NOT.GRANTED--HIVE-2906.D2499.5.patch, HIVE-2906.D2499.6.patch
Some properties are needed to be provided to StorageHandler by user in
runtime. It might be an address for remote resource or retry count for
access or maximum version count(for hbase), etc.
For example,
{code}
select emp.empno, emp.ename from hbase_emp ('max.version'='3') emp;
{code}
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA
administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (HIVE-2906) Support providing some table properties by user via SQL
[
https://issues.apache.org/jira/browse/HIVE-2906?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13713264#comment-13713264
]
Navis commented on HIVE-2906:
-
This patch was very useful for implementing custom storage handler which needs
runtime configurations.
Support providing some table properties by user via SQL
---
Key: HIVE-2906
URL: https://issues.apache.org/jira/browse/HIVE-2906
Project: Hive
Issue Type: Improvement
Components: Query Processor
Reporter: Navis
Assignee: Navis
Attachments: ASF.LICENSE.NOT.GRANTED--HIVE-2906.D2499.1.patch,
ASF.LICENSE.NOT.GRANTED--HIVE-2906.D2499.2.patch,
ASF.LICENSE.NOT.GRANTED--HIVE-2906.D2499.3.patch,
ASF.LICENSE.NOT.GRANTED--HIVE-2906.D2499.4.patch,
ASF.LICENSE.NOT.GRANTED--HIVE-2906.D2499.5.patch, HIVE-2906.D2499.6.patch
Some properties are needed to be provided to StorageHandler by user in
runtime. It might be an address for remote resource or retry count for access
or maximum version count(for hbase), etc.
For example,
{code}
select emp.empno, emp.ename from hbase_emp ('max.version'='3') emp;
{code}
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (HIVE-2906) Support providing some table properties by user via SQL
[
https://issues.apache.org/jira/browse/HIVE-2906?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13645664#comment-13645664
]
patrick o'leary commented on HIVE-2906:
---
Are there any plans on incorporating this patch? Or is there an alternative
Support providing some table properties by user via SQL
---
Key: HIVE-2906
URL: https://issues.apache.org/jira/browse/HIVE-2906
Project: Hive
Issue Type: Improvement
Components: Query Processor
Reporter: Navis
Assignee: Navis
Attachments: ASF.LICENSE.NOT.GRANTED--HIVE-2906.D2499.1.patch,
ASF.LICENSE.NOT.GRANTED--HIVE-2906.D2499.2.patch,
ASF.LICENSE.NOT.GRANTED--HIVE-2906.D2499.3.patch,
ASF.LICENSE.NOT.GRANTED--HIVE-2906.D2499.4.patch,
ASF.LICENSE.NOT.GRANTED--HIVE-2906.D2499.5.patch
Some properties are needed to be provided to StorageHandler by user in
runtime. It might be an address for remote resource or retry count for access
or maximum version count(for hbase), etc.
For example,
{code}
select emp.empno, emp.ename from hbase_emp ('max.version'='3') emp;
{code}
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (HIVE-2906) Support providing some table properties by user via SQL
[
https://issues.apache.org/jira/browse/HIVE-2906?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13240863#comment-13240863
]
Phabricator commented on HIVE-2906:
---
navis has commented on the revision HIVE-2906 [jira] Support providing some
table properties by user via SQL.
It was intended for specifying 'max version' for hbase handler and it seemed
require some modifications. So I was thinking it could be done in a separated
issue after this. But if it's OK, I'll work on that in this issue, too.
REVISION DETAIL
https://reviews.facebook.net/D2499
Support providing some table properties by user via SQL
---
Key: HIVE-2906
URL: https://issues.apache.org/jira/browse/HIVE-2906
Project: Hive
Issue Type: Improvement
Components: Query Processor
Reporter: Navis
Assignee: Navis
Attachments: HIVE-2906.D2499.1.patch
Some properties are needed to be provided to StorageHandler by user in
runtime. It might be an address for remote resource or retry count for access
or maximum version count(for hbase), etc.
For example,
{code}
select emp.empno, emp.ename from hbase_emp ('max.version'='3') emp;
{code}
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (HIVE-2906) Support providing some table properties by user via SQL
[
https://issues.apache.org/jira/browse/HIVE-2906?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13240187#comment-13240187
]
Phabricator commented on HIVE-2906:
---
njain has commented on the revision HIVE-2906 [jira] Support providing some
table properties by user via SQL.
Can you add a test where the value is actually being used ?
REVISION DETAIL
https://reviews.facebook.net/D2499
Support providing some table properties by user via SQL
---
Key: HIVE-2906
URL: https://issues.apache.org/jira/browse/HIVE-2906
Project: Hive
Issue Type: Improvement
Components: Query Processor
Reporter: Navis
Assignee: Navis
Attachments: HIVE-2906.D2499.1.patch
Some properties are needed to be provided to StorageHandler by user in
runtime. It might be an address for remote resource or retry count for access
or maximum version count(for hbase), etc.
For example,
{code}
select emp.empno, emp.ename from hbase_emp ('max.version'='3') emp;
{code}
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
