You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Jackson Chung (JIRA)" <ji...@apache.org> on 2012/05/01 02:21:51 UTC

[jira] [Created] (CASSANDRA-4204) Pig does not work on DateType

Jackson Chung created CASSANDRA-4204:
----------------------------------------

             Summary: Pig does not work on DateType
                 Key: CASSANDRA-4204
                 URL: https://issues.apache.org/jira/browse/CASSANDRA-4204
             Project: Cassandra
          Issue Type: Bug
            Reporter: Jackson Chung
         Attachments: pig_1335816404547.log

cqlsh:PigDemo> describe columnfamily test1897;

CREATE COLUMNFAMILY test1897 (
KEY text PRIMARY KEY,
testcol timestamp
) WITH
comment='' AND
comparator=text AND
row_cache_provider='SerializingCacheProvider' AND
key_cache_size=200000.000000 AND
row_cache_size=0.000000 AND
read_repair_chance=1.000000 AND
gc_grace_seconds=864000 AND
default_validation=blob AND
min_compaction_threshold=4 AND
max_compaction_threshold=32 AND
row_cache_save_period_in_seconds=0 AND
key_cache_save_period_in_seconds=14400 AND
replicate_on_write=True;

cqlsh:PigDemo> select * from test1897;
KEY | testcol
-----+-------------------------
akey | 2012-01-21 00:14:12+0000

$ cat test1897.pig
cassandra_data = LOAD 'cassandra://PigDemo/test1897' USING CassandraStorage() AS (name, columns: bag {T: tuple()});
dump cassandra_data;

there seems problem with the DateType. the above simple pig script fail with the attached err


--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Assigned] (CASSANDRA-4204) Pig does not work on DateType

Posted by "Brandon Williams (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/CASSANDRA-4204?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Brandon Williams reassigned CASSANDRA-4204:
-------------------------------------------

    Assignee: Brandon Williams
    
> Pig does not work on DateType
> -----------------------------
>
>                 Key: CASSANDRA-4204
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-4204
>             Project: Cassandra
>          Issue Type: Bug
>            Reporter: Jackson Chung
>            Assignee: Brandon Williams
>         Attachments: pig_1335816404547.log
>
>
> cqlsh:PigDemo> describe columnfamily test1897;
> CREATE COLUMNFAMILY test1897 (
> KEY text PRIMARY KEY,
> testcol timestamp
> ) WITH
> comment='' AND
> comparator=text AND
> row_cache_provider='SerializingCacheProvider' AND
> key_cache_size=200000.000000 AND
> row_cache_size=0.000000 AND
> read_repair_chance=1.000000 AND
> gc_grace_seconds=864000 AND
> default_validation=blob AND
> min_compaction_threshold=4 AND
> max_compaction_threshold=32 AND
> row_cache_save_period_in_seconds=0 AND
> key_cache_save_period_in_seconds=14400 AND
> replicate_on_write=True;
> cqlsh:PigDemo> select * from test1897;
> KEY | testcol
> -----+-------------------------
> akey | 2012-01-21 00:14:12+0000
> $ cat test1897.pig
> cassandra_data = LOAD 'cassandra://PigDemo/test1897' USING CassandraStorage() AS (name, columns: bag {T: tuple()});
> dump cassandra_data;
> there seems problem with the DateType. the above simple pig script fail with the attached err

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Resolved] (CASSANDRA-4204) Pig does not work on DateType

Posted by "Brandon Williams (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/CASSANDRA-4204?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Brandon Williams resolved CASSANDRA-4204.
-----------------------------------------

    Resolution: Fixed

Committed.
                
> Pig does not work on DateType
> -----------------------------
>
>                 Key: CASSANDRA-4204
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-4204
>             Project: Cassandra
>          Issue Type: Bug
>            Reporter: Jackson Chung
>            Assignee: Brandon Williams
>             Fix For: 1.0.10
>
>         Attachments: 4204.txt, pig_1335816404547.log
>
>
> cqlsh:PigDemo> describe columnfamily test1897;
> CREATE COLUMNFAMILY test1897 (
> KEY text PRIMARY KEY,
> testcol timestamp
> ) WITH
> comment='' AND
> comparator=text AND
> row_cache_provider='SerializingCacheProvider' AND
> key_cache_size=200000.000000 AND
> row_cache_size=0.000000 AND
> read_repair_chance=1.000000 AND
> gc_grace_seconds=864000 AND
> default_validation=blob AND
> min_compaction_threshold=4 AND
> max_compaction_threshold=32 AND
> row_cache_save_period_in_seconds=0 AND
> key_cache_save_period_in_seconds=14400 AND
> replicate_on_write=True;
> cqlsh:PigDemo> select * from test1897;
> KEY | testcol
> -----+-------------------------
> akey | 2012-01-21 00:14:12+0000
> $ cat test1897.pig
> cassandra_data = LOAD 'cassandra://PigDemo/test1897' USING CassandraStorage() AS (name, columns: bag {T: tuple()});
> dump cassandra_data;
> there seems problem with the DateType. the above simple pig script fail with the attached err

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Updated] (CASSANDRA-4204) Pig does not work on DateType

Posted by "Brandon Williams (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/CASSANDRA-4204?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Brandon Williams updated CASSANDRA-4204:
----------------------------------------

    Attachment: 4204.txt

Sad patch w/test to cast DateType to a long, since pig has no native date type, and DateType is just a long under the hood anyway.
                
> Pig does not work on DateType
> -----------------------------
>
>                 Key: CASSANDRA-4204
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-4204
>             Project: Cassandra
>          Issue Type: Bug
>            Reporter: Jackson Chung
>            Assignee: Brandon Williams
>             Fix For: 1.0.10
>
>         Attachments: 4204.txt, pig_1335816404547.log
>
>
> cqlsh:PigDemo> describe columnfamily test1897;
> CREATE COLUMNFAMILY test1897 (
> KEY text PRIMARY KEY,
> testcol timestamp
> ) WITH
> comment='' AND
> comparator=text AND
> row_cache_provider='SerializingCacheProvider' AND
> key_cache_size=200000.000000 AND
> row_cache_size=0.000000 AND
> read_repair_chance=1.000000 AND
> gc_grace_seconds=864000 AND
> default_validation=blob AND
> min_compaction_threshold=4 AND
> max_compaction_threshold=32 AND
> row_cache_save_period_in_seconds=0 AND
> key_cache_save_period_in_seconds=14400 AND
> replicate_on_write=True;
> cqlsh:PigDemo> select * from test1897;
> KEY | testcol
> -----+-------------------------
> akey | 2012-01-21 00:14:12+0000
> $ cat test1897.pig
> cassandra_data = LOAD 'cassandra://PigDemo/test1897' USING CassandraStorage() AS (name, columns: bag {T: tuple()});
> dump cassandra_data;
> there seems problem with the DateType. the above simple pig script fail with the attached err

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Updated] (CASSANDRA-4204) Pig does not work on DateType

Posted by "Brandon Williams (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/CASSANDRA-4204?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Brandon Williams updated CASSANDRA-4204:
----------------------------------------

    Fix Version/s: 1.0.10
    
> Pig does not work on DateType
> -----------------------------
>
>                 Key: CASSANDRA-4204
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-4204
>             Project: Cassandra
>          Issue Type: Bug
>            Reporter: Jackson Chung
>            Assignee: Brandon Williams
>             Fix For: 1.0.10
>
>         Attachments: pig_1335816404547.log
>
>
> cqlsh:PigDemo> describe columnfamily test1897;
> CREATE COLUMNFAMILY test1897 (
> KEY text PRIMARY KEY,
> testcol timestamp
> ) WITH
> comment='' AND
> comparator=text AND
> row_cache_provider='SerializingCacheProvider' AND
> key_cache_size=200000.000000 AND
> row_cache_size=0.000000 AND
> read_repair_chance=1.000000 AND
> gc_grace_seconds=864000 AND
> default_validation=blob AND
> min_compaction_threshold=4 AND
> max_compaction_threshold=32 AND
> row_cache_save_period_in_seconds=0 AND
> key_cache_save_period_in_seconds=14400 AND
> replicate_on_write=True;
> cqlsh:PigDemo> select * from test1897;
> KEY | testcol
> -----+-------------------------
> akey | 2012-01-21 00:14:12+0000
> $ cat test1897.pig
> cassandra_data = LOAD 'cassandra://PigDemo/test1897' USING CassandraStorage() AS (name, columns: bag {T: tuple()});
> dump cassandra_data;
> there seems problem with the DateType. the above simple pig script fail with the attached err

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Commented] (CASSANDRA-4204) Pig does not work on DateType

Posted by "Brandon Williams (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/CASSANDRA-4204?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13266014#comment-13266014 ] 

Brandon Williams commented on CASSANDRA-4204:
---------------------------------------------

Just noticed we're actually returning a byte array here, so I changed this to a long in 2b7672fa11efa6e8c3c5cbc6fa857b3bc8947092
                
> Pig does not work on DateType
> -----------------------------
>
>                 Key: CASSANDRA-4204
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-4204
>             Project: Cassandra
>          Issue Type: Bug
>            Reporter: Jackson Chung
>            Assignee: Brandon Williams
>             Fix For: 1.0.10
>
>         Attachments: 4204.txt, pig_1335816404547.log
>
>
> cqlsh:PigDemo> describe columnfamily test1897;
> CREATE COLUMNFAMILY test1897 (
> KEY text PRIMARY KEY,
> testcol timestamp
> ) WITH
> comment='' AND
> comparator=text AND
> row_cache_provider='SerializingCacheProvider' AND
> key_cache_size=200000.000000 AND
> row_cache_size=0.000000 AND
> read_repair_chance=1.000000 AND
> gc_grace_seconds=864000 AND
> default_validation=blob AND
> min_compaction_threshold=4 AND
> max_compaction_threshold=32 AND
> row_cache_save_period_in_seconds=0 AND
> key_cache_save_period_in_seconds=14400 AND
> replicate_on_write=True;
> cqlsh:PigDemo> select * from test1897;
> KEY | testcol
> -----+-------------------------
> akey | 2012-01-21 00:14:12+0000
> $ cat test1897.pig
> cassandra_data = LOAD 'cassandra://PigDemo/test1897' USING CassandraStorage() AS (name, columns: bag {T: tuple()});
> dump cassandra_data;
> there seems problem with the DateType. the above simple pig script fail with the attached err

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Updated] (CASSANDRA-4204) Pig does not work on DateType

Posted by "Jackson Chung (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/CASSANDRA-4204?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jackson Chung updated CASSANDRA-4204:
-------------------------------------

    Attachment: pig_1335816404547.log
    
> Pig does not work on DateType
> -----------------------------
>
>                 Key: CASSANDRA-4204
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-4204
>             Project: Cassandra
>          Issue Type: Bug
>            Reporter: Jackson Chung
>         Attachments: pig_1335816404547.log
>
>
> cqlsh:PigDemo> describe columnfamily test1897;
> CREATE COLUMNFAMILY test1897 (
> KEY text PRIMARY KEY,
> testcol timestamp
> ) WITH
> comment='' AND
> comparator=text AND
> row_cache_provider='SerializingCacheProvider' AND
> key_cache_size=200000.000000 AND
> row_cache_size=0.000000 AND
> read_repair_chance=1.000000 AND
> gc_grace_seconds=864000 AND
> default_validation=blob AND
> min_compaction_threshold=4 AND
> max_compaction_threshold=32 AND
> row_cache_save_period_in_seconds=0 AND
> key_cache_save_period_in_seconds=14400 AND
> replicate_on_write=True;
> cqlsh:PigDemo> select * from test1897;
> KEY | testcol
> -----+-------------------------
> akey | 2012-01-21 00:14:12+0000
> $ cat test1897.pig
> cassandra_data = LOAD 'cassandra://PigDemo/test1897' USING CassandraStorage() AS (name, columns: bag {T: tuple()});
> dump cassandra_data;
> there seems problem with the DateType. the above simple pig script fail with the attached err

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Updated] (CASSANDRA-4204) Pig does not work on DateType

Posted by "Rick Branson (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/CASSANDRA-4204?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Rick Branson updated CASSANDRA-4204:
------------------------------------

    Reviewer: rbranson

Reviewed, looks good.
                
> Pig does not work on DateType
> -----------------------------
>
>                 Key: CASSANDRA-4204
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-4204
>             Project: Cassandra
>          Issue Type: Bug
>            Reporter: Jackson Chung
>            Assignee: Brandon Williams
>             Fix For: 1.0.10
>
>         Attachments: 4204.txt, pig_1335816404547.log
>
>
> cqlsh:PigDemo> describe columnfamily test1897;
> CREATE COLUMNFAMILY test1897 (
> KEY text PRIMARY KEY,
> testcol timestamp
> ) WITH
> comment='' AND
> comparator=text AND
> row_cache_provider='SerializingCacheProvider' AND
> key_cache_size=200000.000000 AND
> row_cache_size=0.000000 AND
> read_repair_chance=1.000000 AND
> gc_grace_seconds=864000 AND
> default_validation=blob AND
> min_compaction_threshold=4 AND
> max_compaction_threshold=32 AND
> row_cache_save_period_in_seconds=0 AND
> key_cache_save_period_in_seconds=14400 AND
> replicate_on_write=True;
> cqlsh:PigDemo> select * from test1897;
> KEY | testcol
> -----+-------------------------
> akey | 2012-01-21 00:14:12+0000
> $ cat test1897.pig
> cassandra_data = LOAD 'cassandra://PigDemo/test1897' USING CassandraStorage() AS (name, columns: bag {T: tuple()});
> dump cassandra_data;
> there seems problem with the DateType. the above simple pig script fail with the attached err

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira