[jira] [Commented] (HIVE-14404) Allow delimiterfordsv to use multiple-character delimiters
[ https://issues.apache.org/jira/browse/HIVE-14404?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15407680#comment-15407680 ] Stephen Measmer commented on HIVE-14404: My preference would be #2 as Super CSV does not look like its an Apache project. Making the change in the context of hive would contribute to supportability. > Allow delimiterfordsv to use multiple-character delimiters > -- > > Key: HIVE-14404 > URL: https://issues.apache.org/jira/browse/HIVE-14404 > Project: Hive > Issue Type: Improvement >Reporter: Stephen Measmer >Assignee: Marta Kuczora > > HIVE-5871 allows for reading multiple character delimiters. Would like the > ability to use outputformat=dsv and define multiple character delimiters. > Today delimiterfordsv only uses on character even if multiple are passes. > For example: > when I use: > beeline>!set outputformat dsv > beeline>!set delimiterfordsv "^-^" > I get: > 111201081253106275^31-Oct-2011 > 00:00:00^Text^201605232823^2016051968232151^201605232823_2016051968232151_0_0_1 > > Would like it to be: > 111201081253106275^-^31-Oct-2011 > 00:00:00^-^Text^-^201605232823^-^2016051968232151^-^201605232823_2016051968232151_0_0_1 > -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HIVE-10070) Document how to migrate from MySQL or Postgres DB to Oracle
[ https://issues.apache.org/jira/browse/HIVE-10070?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Stephen Measmer updated HIVE-10070: --- Description: User is using Oracle SQLDeveloper to migrate from MySQL to Oracle . They did not find steps in documentation on any special tasks that must be done. We provided steps of running the Hive schema install scripts then using the tool to copy the data.(was: Customer request from ticket 55078 (https://na6.salesforce.com/500800ggyp8AAA ) Customer is using Oracle SQLDeveloper to migrate from MySQL to Oracle . They did not find steps in documentation on any special tasks that must be done. We provided steps of running the Hive schema install scripts then using the tool to copy the data. ) > Document how to migrate from MySQL or Postgres DB to Oracle > --- > > Key: HIVE-10070 > URL: https://issues.apache.org/jira/browse/HIVE-10070 > Project: Hive > Issue Type: Improvement >Reporter: Stephen Measmer > > User is using Oracle SQLDeveloper to migrate from MySQL to Oracle . They did > not find steps in documentation on any special tasks that must be done. We > provided steps of running the Hive schema install scripts then using the tool > to copy the data. -- This message was sent by Atlassian JIRA (v6.3.4#6332)