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