Exception trying to write an ARRAY of UNSIGNED_SMALLINT

2015-08-04 Thread Riccardo Cardin
Hi all, I am using Phoenix version 4.5.0 and the phoenix-spark plugin to write into HBase an ARRAY of UNSIGNED_SMALLINT. As stated in the documentation, this type is mapped to the java type java.lang.Short. Using the saveToPhoenix method on a RDD and passing a Scala Array of Short I obtain the

Re: Date math

2015-08-04 Thread Michael McAllister
James Thanks for writing back. Some feedback:- Not sure if this is in 4.2, but Phoenix supports casting a numeric to a date. So when I am referring to a numeric version of a date, I’m referring to a date that has been formatted as MMDD, and then put in an integer. I am not talking about

Re: Exception trying to write an ARRAY of UNSIGNED_SMALLINT

2015-08-04 Thread Josh Mahonin
Hi Riccardo, I think you've run into a bit of a mismatch between Scala and Java types. Could you please file a JIRA ticket for this with all the info above? You should be able to work around this by first converting your array contents to be java.lang.Short. I just tried this out and it worked

Date math

2015-08-04 Thread Michael McAllister
Hi I have a table with a date stored in it. The date is always the last day of a month. For example, 31-AUG-2015 or 28-FEB-2015. I have the date stored in two separate columns. In one place it is an integer (20150831 and 20150228). In another place it uses the DATE datatype. I want to write a