[
https://issues.apache.org/jira/browse/CASSANDRA-4943?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13494743#comment-13494743
]
Aleksey Yeschenko commented on CASSANDRA-4943:
----------------------------------------------
The error sounds familiar, has been fixed quite a while ago.
For completeness, here is the output I get when running your queries (1.2,
trunk):
~/Repos/ASF/cassandra ➤ bin/cqlsh
Connected to Test Cluster at 127.0.0.1:9160.
[cqlsh 2.3.0 | Cassandra 1.2.0-beta2-SNAPSHOT | CQL spec 3.0.0 | Thrift
protocol 19.35.0]
Use HELP for help.
cqlsh> create keyspace videos WITH replication = {'class': 'SimpleStrategy',
'replication_factor': 1};
cqlsh> use videos ;
cqlsh:videos> CREATE TABLE video_logging (
... videoidandtime varchar,
... hour int,
... eid timeuuid,
... event varchar ,
... PRIMARY KEY( videoidandtime , hour, eid)
... ) WITH COMPACT STORAGE;
cqlsh:videos> insert INTO video_logging (videoidandtime,hour,eid,event) values
('123|2012_01_02',3,'now','liked:bob');
cqlsh:videos> insert INTO video_logging (videoidandtime,hour,eid,event) values
('123|2012_01_02',3,'now','watched:sara');
cqlsh:videos> insert INTO video_logging (videoidandtime,hour,eid,event) values
('123|2012_01_02',3,'now','liked:sara');
cqlsh:videos> select * from video_logging;
videoidandtime | hour | eid | event
----------------+------+--------------------------+--------------
123|2012_01_02 | 3 | 2012-11-10 21:37:24+0300 | liked:bob
123|2012_01_02 | 3 | 2012-11-10 21:37:35+0300 | watched:sara
123|2012_01_02 | 3 | 2012-11-10 21:37:48+0300 | liked:sara
> CQL3 global name 'unix_time_from_uuid1' is not defined
> ------------------------------------------------------
>
> Key: CASSANDRA-4943
> URL: https://issues.apache.org/jira/browse/CASSANDRA-4943
> Project: Cassandra
> Issue Type: Bug
> Affects Versions: 1.2.0 beta 1
> Reporter: Edward Capriolo
> Assignee: Aleksey Yeschenko
>
> 1.
> cqlsh:videos> CREATE TABLE video_logging (
> 2.
> ... videoidandtime varchar,
> 3.
> ... hour int,
> 4.
> ... eid timeuuid,
> 5.
> ... event varchar ,
> 6.
> ... PRIMARY KEY( videoidandtime , hour, eid)
> 7.
> ... ) WITH COMPACT STORAGE;
> 8.
> cqlsh:videos> insert INTO video_logging (videoidandtime,hour,eid,event)
> values ('123|2012_01_02',3,now,'liked:bob');
> 9.
> Bad Request: line 1:85 no viable alternative at input 'now'
> 10.
> cqlsh:videos> insert INTO video_logging (videoidandtime,hour,eid,event)
> values ('123|2012_01_02',3,'now','liked:bob');
> 11.
> cqlsh:videos> insert INTO video_logging (videoidandtime,hour,eid,event)
> values ('123|2012_01_02',3,'now','watched:sara');
> 12.
> cqlsh:videos> insert INTO video_logging (videoidandtime,hour,eid,event)
> values ('123|2012_01_02',3,'now','liked:sara');
> 13.
> cqlsh:videos> select * from video_logging;
> 14.
> global name 'unix_time_from_uuid1' is not defined
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
