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

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"

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 :)

Any ideas?

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