Mailing-List: contact commits-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@cassandra.apache.org
Date: Sat, 10 Nov 2012 18:41:12 +0000 (UTC)
From: "Aleksey Yeschenko (JIRA)" <jira@apache.org>
To: commits@cassandra.apache.org
Message-ID: <695399382.96793.1352572872433.JavaMail.jiratomcat@arcas>
In-Reply-To: <639878507.96769.1352572392649.JavaMail.jiratomcat@arcas>
Subject: [jira] [Commented] (CASSANDRA-4943) CQL3 global name
 'unix_time_from_uuid1' is not defined
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable


    [ https://issues.apache.org/jira/browse/CASSANDRA-4943?page=3Dcom.atlas=
sian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=3D=
13494743#comment-13494743 ]=20

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 =E2=9E=A4 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 pro=
tocol 19.35.0]
Use HELP for help.
cqlsh> create keyspace videos WITH replication =3D {'class': 'SimpleStrateg=
y', '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) val=
ues ('123|2012_01_02',3,'now','liked:bob');
cqlsh:videos> insert INTO video_logging (videoidandtime,hour,eid,event) val=
ues ('123|2012_01_02',3,'now','watched:sara');
cqlsh:videos> insert INTO video_logging (videoidandtime,hour,eid,event) val=
ues ('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
               =20
> 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,ev=
ent) 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,ev=
ent) values ('123|2012_01_02',3,'now','liked:bob');
>   11.
>       cqlsh:videos> insert INTO video_logging (videoidandtime,hour,eid,ev=
ent) values ('123|2012_01_02',3,'now','watched:sara');
>   12.
>       cqlsh:videos> insert INTO video_logging (videoidandtime,hour,eid,ev=
ent) 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 administrato=
rs
For more information on JIRA, see: http://www.atlassian.com/software/jira