Advertisement
Guest User

hive errors with cql3 column family

a guest
Sep 5th, 2013
48
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.90 KB | None | 0 0
  1. hive> create database pns_fr;
  2. OK
  3. Time taken: 0.039 seconds
  4. hive>
  5. > CREATE EXTERNAL TABLE pns_fr.messages(message_id string, author string, body string)
  6. > STORED BY 'org.apache.hadoop.hive.cassandra.cql.CqlStorageHandler'
  7. > WITH SERDEPROPERTIES ("cql.primarykey" = "message_id, author", "comment"="check", "read_repair_chance" = "0.2",
  8. > "dclocal_read_repair_chance" = "0.14", "gc_grace_seconds" = "989898", "bloom_filter_fp_chance" = "0.2",
  9. > "compaction" = "{'class' : 'LeveledCompactionStrategy'}", "replicate_on_write" = "false", "caching" = "all");
  10. OK
  11. Time taken: 0.089 seconds
  12. hive> use pns_fr;
  13. OK
  14. Time taken: 0.014 seconds
  15. hive> select * from messages;
  16. OK
  17. Failed with exception java.io.IOException:java.lang.ClassCastException: org.apache.hadoop.io.MapWritable cannot be cast to org.apache.hadoop.io.WritableComparable
  18. Time taken: 0.43 seconds
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement