aliases for histogram_numeric (a UDTF)

2013-11-05 Thread P Reeder
I'm trying to use histogram_numeric(), and output the results as a table with an x and y column, one row per bin. SELECT histogram_numeric(freight, 10) from flights produces an array of JSON objects: [{"x":25702.200152788293,"y":79849},{"x":2287471.0415704413,"y":866},{"x":5190680.02686567,"y":33

SerDe for Fixed Columns?

2013-10-28 Thread P Reeder
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 fo