Insert time or date on hbase from phoenix

2015-09-21 Thread Alberto Gonzalez Mesas
I can't put cells with timestamp into hbase. If put a timestamp "10/10/2015 22:34:21" in hbase and i create a view in phoenix, phoenix not recognized the data. ¿Why? EJ. ++ Create and put data into hbase: Hbase> create 'table1', 'c' Hbase> put 'table1', 'row1', 'c:timestamp', '23/09/2015 14

RE: Error: Encountered exception in sub plan [0] execution.

2015-09-21 Thread Alberto Gonzalez Mesas
there's an ERROR, probably something like InsufficientMemoryException? Thanks,Maryann On Fri, Sep 11, 2015 at 7:04 AM, Alberto Gonzalez Mesas wrote: Hi! I create two tables: CREATE TABLE "Customers2" ("CustomerID" VARCHAR NOT NULL PRIMARY KEY, "C"."

Error: Encountered exception in sub plan [0] execution.

2015-09-11 Thread Alberto Gonzalez Mesas
Hi! I create two tables: CREATE TABLE "Customers2" ("CustomerID" VARCHAR NOT NULL PRIMARY KEY, "C"."CustomerName" VARCHAR, "C"."Country" VARCHAR ) and CREATE TABLE "Orders2" ("OrderID" VARCHAR NOT NULL PRIMARY KEY, "O"."CustomerID" VARCHAR, "O"."Date" VARCHAR, "O"."ItemID" V