Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
Hive >> mail # user >> Hive create table


+
jinhang du 2011-05-25, 11:56
Copy link to this message
-
Re: Hive create table
Hi Jinhang
       I don't think hive supports multi character delimiters. The hassle free option here would be to preprocess the data using mapreduce to replace the multi character delimiter with another permissible one that suits your data.
Regards
Bejoy K S

-----Original Message-----
From: jinhang du <[EMAIL PROTECTED]>
Date: Wed, 25 May 2011 19:56:16
To: <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Subject: Hive create table

Hi all,

I want to custom the delimiter of the table in a row.
Like my data format is '1&&&&2&&&&4‘, and how could I create a table (int,
int, int)

Thanks.

--
dujinhang

+
valentina kroshilina 2011-05-25, 13:57
+
jinhang du 2011-05-26, 01:50
+
jinhang du 2011-05-27, 12:07
+
bangbig 2011-05-27, 15:21
+
jinhang du 2011-05-30, 04:50