AS t" to get meta information is too expensive for big tables
[ https://issues.apache.org/jira/browse/MAPREDUCE-1224?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Tom White updated MAPREDUCE-1224:
---------------------------------
Resolution: Fixed
Fix Version/s: 0.22.0
Assignee: Spencer Ho
Status: Resolved (was: Patch Available)
I've just committed this. Thanks Spencer!
> Calling "SELECT t.* from <table> AS t" to get meta information is too expensive for big tables
> ----------------------------------------------------------------------------------------------
>
> Key: MAPREDUCE-1224
> URL: https://issues.apache.org/jira/browse/MAPREDUCE-1224
> Project: Hadoop Map/Reduce
> Issue Type: Improvement
> Components: contrib/sqoop
> Affects Versions: 0.20.1
> Environment: all platforms, generic jdbc driver
> Reporter: Spencer Ho
> Assignee: Spencer Ho
> Fix For: 0.22.0
>
> Attachments: MAPREDUCE-1224.patch, SqlManager.java
>
>
> The SqlManager uses the query, "SELECT t.* from <table> AS t" to get table spec is too expensive for big tables, and it was called twice to generate column names and types. For tables that are big enough to be map-reduced, this is too expensive to make sqoop useful.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.