Test case using PortfolioDemo.
The script 10_day_loss.q was run populating HistLoss.
cassandra-cli was then run with the following commands:
[default@unknown] connect localhost/9160;
Connected to: "Test Cluster" on localhost/9160
[default@unknown] use PortfolioDemo;
Authenticated to keyspace: PortfolioDemo
[default@PortfolioDemo] set HistLoss['100']['test']='test';
Elapsed time: 23 msec(s).
[default@PortfolioDemo] get HistLoss[utf8('100')]
=> (column=loss, value=-1492.8402867337113, timestamp=1334287269078)
=> (column=test, value=test, timestamp=1334287414757000)
=> (column=worst_date, value=2012-02-07, timestamp=1334287269078)
Returned 3 results.
Elapsed time: 14 msec(s).
The timestamps for loss and worst_date are 1970-01-16 20:38:07.269
The time stamp for test is 2012-04-13 13:23:34.757
Is there some setting required for Hive to insert the correct timestamps?