cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Aleksey Yeschenko (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CASSANDRA-4943) CQL3 global name 'unix_time_from_uuid1' is not defined
Date Sat, 10 Nov 2012 18:41:12 GMT

    [ 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

Mime
View raw message