[ https://issues.apache.org/jira/browse/CASSANDRA-3280?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Steeve Morin updated CASSANDRA-3280: ------------------------------------ Description: Various patches in the Pig Storage Handler: - correctly guess the right Pig type for the Row Key - add support for FloatType, DoubleType, -UUIDType (as String) and DateType (as time epoch)- (removed in v2 because it would break when storing data back in Cassandra) - add support to specify correct type comparator in SlicePredicate *SlicePredicate comparator:* For instance: {quote} {{raw = LOAD 'cassandra://ks/cf?slice_start=2.5&slice_end=5.3&comparator=DoubleType' USING CassandraStorage() AS ();}} {quote} It's an optional parameter. If it's not present, it will default to BytesType. Which mean you must use hex strings. Hence {{slice_start=00&slice_end=FF}} isn't the same as {{slice_start=00&slice_end=FF&comparator=AsciiType}} ! was: Various patches in the Pig Storage Handler: - correctly guess the right Pig type for the Row Key - add support for FloatType, DoubleType, UUIDType (as String) and DateType (as time epoch) - add support to specify correct type comparator in SlicePredicate *SlicePredicate comparator:* For instance: {quote} {{raw = LOAD 'cassandra://ks/cf?slice_start=2.5&slice_end=5.3&comparator=DoubleType' USING CassandraStorage() AS ();}} {quote} It's an optional parameter. If it's not present, it will default to BytesType. Which mean you must use hex strings. Hence {{slice_start=00&slice_end=FF}} isn't the same as {{slice_start=00&slice_end=FF&comparator=AsciiType}} ! > Pig Storage Handler: Add >=0.8.1 types, Guess right type for Key in Schema > -------------------------------------------------------------------------- > > Key: CASSANDRA-3280 > URL: https://issues.apache.org/jira/browse/CASSANDRA-3280 > Project: Cassandra > Issue Type: Improvement > Components: Hadoop > Affects Versions: 0.8.1 > Reporter: Steeve Morin > Labels: patch > Fix For: 0.8.7 > > Attachments: new_types_and_key_type.txt, new_types_and_key_type_v2.txt > > > Various patches in the Pig Storage Handler: > - correctly guess the right Pig type for the Row Key > - add support for FloatType, DoubleType, -UUIDType (as String) and DateType > (as time epoch)- (removed in v2 because it would break when storing data back > in Cassandra) > - add support to specify correct type comparator in SlicePredicate > *SlicePredicate comparator:* > For instance: > {quote} > {{raw = LOAD > 'cassandra://ks/cf?slice_start=2.5&slice_end=5.3&comparator=DoubleType' USING > CassandraStorage() AS ();}} > {quote} > It's an optional parameter. If it's not present, it will default to > BytesType. Which mean you must use hex strings. > Hence {{slice_start=00&slice_end=FF}} isn't the same as > {{slice_start=00&slice_end=FF&comparator=AsciiType}} ! -- 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