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

Switch to Threaded View
Hive, mail # user - SerDe for Fixed Columns?


Copy link to this message
-
Re: SerDe for Fixed Columns?
Nitin Pawar 2013-10-28, 20:03
I am not aware of any such serde.

Till others reply you can wait
or if you are in hurry then load the data in a table as single column and
then use substring method to select and load data into proper table.
On Tue, Oct 29, 2013 at 1:18 AM, P Reeder <[EMAIL PROTECTED]>wrote:

>  Hi! Sorry to ask such a basic question, but ****
>
> ** **
>
> How do I import data from a text file with fixed columns (no delimiter)?
> I.e, column 1 is characters 1-6, column 2 is characters 7-11, column 3 is
> character 12, column 4 is character 13, and so forth?  I’d be surprised if
> no one has written a SerDe for this.  ****
>
> ** **
>
> The manual talks about a MetadataTypedColumnsetSerDe, a ThriftSerDe, a
> DynamicSerDe, and SerDes for JSON, Avro and ORC.  I also searched Bing for
> “site:mail-archives.apache.org/mod_mbox/hive-user/ serde fixed”, but that
> didn’t appear to have anything relevant.****
>
> ** **
>
> FWIW, the dataset is the National Immunization Survey:
> http://www.cdc.gov/nchs/nis/data_files.htm****
>
> DISCLAIMER ========== This e-mail may contain privileged and confidential
> information which is the property of Persistent Systems Ltd. It is intended
> only for the use of the individual or entity to which it is addressed. If
> you are not the intended recipient, you are not authorized to read, retain,
> copy, print, distribute or use this message. If you have received this
> communication in error, please notify the sender and delete all copies of
> this message. Persistent Systems Ltd. does not accept any liability for
> virus infected mails.
>

--
Nitin Pawar