Re: Multi character delimiter for Hive Columns and Rows

2011-04-28 Thread Richard Nadeau
; Sent: Tue, April 26, 2011 11:05:46 PM > Subject: Multi character delimiter for Hive Columns and Rows > > > Hello, > > We have a situation where the data coming from source systems to hive may > contain the common characters and delimiters such as |, tabs, new line > characters

Re: Multi character delimiter for Hive Columns and Rows

2011-04-28 Thread Shantian Purkad
Any suggestions? From: Shantian Purkad To: user@hive.apache.org Sent: Tue, April 26, 2011 11:05:46 PM Subject: Multi character delimiter for Hive Columns and Rows Hello, We have a situation where the data coming from source systems to hive may contain the

Multi character delimiter for Hive Columns and Rows

2011-04-26 Thread Shantian Purkad
Hello, We have a situation where the data coming from source systems to hive may contain the common characters and delimiters such as |, tabs, new line characters etc. We may have to use multi character delimiters such as "|#" for columns and "||#" for rows. How can we achieve this? In this