[
https://issues.apache.org/jira/browse/PIG-2676?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13501637#comment-13501637
]
Jeff Markham commented on PIG-2676:
-----------------------------------
I can take on this one. I'll use the storage location and the schema on LOAD
AS to generate the SELECT statement. I'll use sensible defaults to create
tuple schema from column name/types and throw in LIMIT/OFFSET to correspond to
number of mappers.
If no objections to the high-level sentence above, go ahead and assign it to me.
> Enable piggybank DBStorage to read from JDBC databases
> ------------------------------------------------------
>
> Key: PIG-2676
> URL: https://issues.apache.org/jira/browse/PIG-2676
> Project: Pig
> Issue Type: Improvement
> Components: piggybank
> Affects Versions: 0.9.2, 0.10.0, 0.11, 0.10.1
> Reporter: Russell Jurney
> Priority: Critical
> Labels: dance, data, fun, happy, io, jdbc, mysql, pants, pig,
> silly, sloppy, sql
> Fix For: 0.10.1
>
>
> I would like to load data from a SQL DB using a SQL SELECT query. DBStorage
> does not implement loading data, getNext, etc.
--
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
