Thanks, I've got it working. I am making a chart UDF, to convert BigInts from count(6) to ******
I am trying to find a way to select TimeSeries(count(*)) and group by day, but this results in an error:
select to_date(dt) as total, TimeSeries(CAST(count(*) AS INT)) as stars, count(*) as total from from_to group by to_date(dt) order by to_date(dt);
FAILED: Error in semantic analysis: Line 5:16 Invalid table alias or column reference 'total': (possible column names are: from_address, to_address, dt)
I can't seem to select a to_date(dt) value and also group AND order by it. I need to order by it to get my time series :)
On Wed, May 30, 2012 at 9:58 PM, Aniket Mokashi <[EMAIL PROTECTED]> wrote:
> If this is UDF, you will need hive-exec.jar to compile it. I am not sure > what is the use of this udf. > > Serde has following interface-- > > public interface SerDe extends Deserializer, Serializer > > ~Aniket > > On Wed, May 30, 2012 at 9:51 PM, Russell Jurney <[EMAIL PROTECTED]>wrote: > >> I tried to make a simple Serde that converted Ints to ***** for a time >> series/distribution chart. >> >> https://github.com/rjurney/timeseriesserde >> >> I get this error: https://gist.github.com/2841090 >> >> -- >> Russell Jurney twitter.com/rjurney [EMAIL PROTECTED] datasyndrome. >> com >> > > > > -- > "...:::Aniket:::... Quetzalco@tl" >
-- Russell Jurney twitter.com/rjurney [EMAIL PROTECTED] datasyndrome.com
Russell Jurney 2012-05-31, 06:30
NEW: Monitor These Apps!
All projects made searchable here are trademarks of the Apache Software Foundation.
Service operated by Sematext