Sorry, i am not sure about that. I looked into sqoop's code and did not find any reference to that. Try to look into Oraoop. Also some info here: https://community.oracle.com/thread/227790?start=0&tstart=0
On Tue, Sep 30, 2014 at 8:36 AM, Venkat, Ankam <[email protected] > wrote: > Thanks Pratik. > > > > Looks like “Remarks” can be used in Oracle JDBC as well. > > > > But, how do we use this in SQOOP? > > > > Regards, > > Venkat > > > > *From:* pratik khadloya [mailto:[email protected]] > *Sent:* Monday, September 29, 2014 9:48 AM > > *To:* [email protected] > *Subject:* Re: Importing Table and Column comments > > > > I realized that i was wrong about JDBC not providing the column comments > information. > > For mysql, It does provide that information through the mysql connector. > You might have to check one for your database. > > Also check https://issues.apache.org/jira/browse/SQOOP-1456 > > > > Regards, > > Pratik > > > > On Fri, Sep 12, 2014 at 10:18 AM, pratik khadloya <[email protected]> > wrote: > > Sorry, JDBC does not support USER_COL_COMMENTS either (i think this is > specific to oracle). > > I don't think there is any tool currently available which can export mysql > tables to hive other than sqoop. > > > > You might have to write your own custom code for backfilling the comments > after sqoop is done with its import. > > Your custom tool can use something like > http://stackoverflow.com/a/6752206/238880 > > > > > > ~Pratik > > > > On Fri, Sep 12, 2014 at 7:34 AM, Venkat, Ankam < > [email protected]> wrote: > > Thanks Pratik. > > > > How about fetching comments from USER_COL_COMMENTS ? > > > > If not Sqoop, is there any other way to fetch this data? > > > > Regards, > > Venkat > > > > *From:* pratik khadloya [mailto:[email protected]] > *Sent:* Thursday, September 11, 2014 6:09 PM > *To:* [email protected] > *Subject:* Re: Importing Table and Column comments > > > > The problem is that JDBC does not have support for column comments. > > It is not a part of their API. > > Ref: > http://docs.oracle.com/javase/7/docs/api/java/sql/ResultSetMetaData.html > > > > ~Pratik > > > > On Thu, Sep 11, 2014 at 3:13 PM, Venkat, Ankam < > [email protected]> wrote: > > Need this data for our enterprise metadata repository. > > > > Any workaround for this? > > > > Regards, > > Venkat > > > > *From:* pratik khadloya [mailto:[email protected]] > *Sent:* Thursday, September 11, 2014 3:13 PM > *To:* [email protected] > *Subject:* Re: Importing Table and Column comments > > > > I don't think that happens today. I was wondering about the same thing. > > > > On Thu, Sep 11, 2014 at 10:43 AM, Venkat, Ankam < > [email protected]> wrote: > > Is there a way to import table and column comments and store info on Hive? > > > > Regards, > > Venkat Ankam > > > > > > > > >
