Re: csv import with quotes

2011-01-10 Thread Larry Ogrodnek
I wrote a CSVSerde for hive that uses opencsv for csv parsing, so it handles quotes and all other CSV weirdness. I wrote it up here: http://dev.bizo.com/2010/11/csv-and-hive.html On Mon, Jan 10, 2011 at 12:44 PM, ankit bhatnagar wrote: > Hi All, > > I am planning to join some csv files using

Re: csv import with quotes

2011-01-27 Thread Larry Ogrodnek
Are you using the jar I built? It should be: create table my_table(a string, b string, c string) row format serde 'com.bizo.hive.serde.csv.CSVSerde' stored as textfile ; I.e. the class needs to be "com.bizo.hive.serde.csv.CSVSerde" unless you built your own jar? On Fri, Jan 21, 2011 at 1:

UDF constructor params?

2011-04-05 Thread Larry Ogrodnek
For some UDFs I'm working on now it feels like it would be handy to be able to pass in parameters during construction. It's an integration with an external reporting API... e.g. -- include last 30 days from april 4th create temporary function orders_last_month as 'com.example.OrderSearch("201104