Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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?
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
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB