Phoenix UDF is not working for me

2017-03-17 Thread Abhishek Kumar
Hi, I am trying to register my custom UDF in phoenix but it is not working for me. I have put up the details here: http://stackoverflow.com /questions/42825482/phoenix-udf-not-working Everytime I am getting: Error: ERROR 6001 (42F01): Function undefined. functionName=EPOCHTODATE (state=42F01,code

Re: Differences between the date/time types

2017-03-17 Thread Cheyenne Forbes
Anyone?

Re: Differences between the date/time types

2017-03-17 Thread James Taylor
The DATE and TIME types in Phoenix are more or less the same. They store their data as an 8 byte long Epoch time and maintain millisecond granularity. The TIMESTAMP stores nanosecond data in a 12 bytes - an 8 byte long Epoch time plus 4 bytes for nanoseconds. Unless you need nanosecond granularity