[
https://issues.apache.org/jira/browse/TRAFODION-224?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14698010#comment-14698010
]
Atanu Mishra commented on TRAFODION-224:
----------------------------------------
Hans Zeller (hans-zeller) wrote on 2014-09-25: #4
Chong found a problem, a
select count(*) from table(table x, partiion number from x to y)
counts all the rows because it is transformed into a coprocessor aggregate.
Changing the state back to "In Progress" to fix that.
Changed in trafodion:
status: Fix Committed → In Progress
Hans Zeller (hans-zeller) wrote on 2014-10-01: #5
Fix for the count(*) problem was merged to the main branch on 9/29.
https://review.trafodion.org/#/c/464/
Changed in trafodion:
status: In Progress → Fix Committed
Stacey Johnson (sjohnson-w) on 2014-10-16
Changed in trafodion:
milestone: none → r0.8
status: Fix Committed → Fix Released
> LP Bug: 1306836 - Enable syntax to select individual partitions
> ---------------------------------------------------------------
>
> Key: TRAFODION-224
> URL: https://issues.apache.org/jira/browse/TRAFODION-224
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-cmp
> Reporter: Hans Zeller
> Assignee: Hans Zeller
> Priority: Critical
> Labels: performance
> Fix For: 0.9 (pre-incubation)
>
>
> Greg's team wants to extract HBase data in parallel. Right now we don't
> support the Fast Extract ODBC interface yet. To enable parallel extracts with
> a regular ODBC interface, we could enable the syntax to select individual
> partitions:
> select * from table(table mysch.mytable, partition number <n>)
> select * from table(table mysch.mytable, partition number from <n> to <m>)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
