{"action":"closed","issue":{"url":"https://api.github.com/repos/dvasilen/Hive-Cassandra/issues/1","labels_url":"https://api.github.com/repos/dvasilen/Hive-Cassandra/issues/1/labels{/name}","comments_url":"https://api.github.com/repos/dvasilen/Hive-Cassandra/issues/1/comments","events_url":"https://api.github.com/repos/dvasilen/Hive-Cassandra/issues/1/events","html_url":"https://github.com/dvasilen/Hive-Cassandra/issues/1","id":14001210,"number":1,"title":"Duplicated records in Hive query","user":{"login":"oliverzy","id":1321817,"avatar_url":"https://avatars.githubusercontent.com/u/1321817?v=3","gravatar_id":"","url":"https://api.github.com/users/oliverzy","html_url":"https://github.com/oliverzy","followers_url":"https://api.github.com/users/oliverzy/followers","following_url":"https://api.github.com/users/oliverzy/following{/other_user}","gists_url":"https://api.github.com/users/oliverzy/gists{/gist_id}","starred_url":"https://api.github.com/users/oliverzy/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/oliverzy/subscriptions","organizations_url":"https://api.github.com/users/oliverzy/orgs","repos_url":"https://api.github.com/users/oliverzy/repos","events_url":"https://api.github.com/users/oliverzy/events{/privacy}","received_events_url":"https://api.github.com/users/oliverzy/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":5,"created_at":"2013-05-06T13:38:00Z","updated_at":"2015-04-20T12:55:09Z","closed_at":"2015-04-20T12:55:09Z","body":"Hi Dmitry,\r\n\r\nI try your build with cassandra 1.2.3/hive 0.9.0, I have a issue that I always get the duplicated records in Hive.\r\nCassandra column family:\r\nCREATE COLUMN FAMILY users\r\nWITH comparator = UTF8Type\r\nAND key_validation_class=UTF8Type\r\nAND column_metadata = [\r\n{column_name: full_name, validation_class: UTF8Type} {column_name: email, validation_class: UTF8Type} {column_name: state, validation_class: UTF8Type} {column_name: gender, validation_class: UTF8Type} {column_name: birth_year, validation_class: LongType}\r\n];\r\n\r\nHive Table:\r\nCREATE EXTERNAL TABLE IF NOT EXISTS\r\nusers (key string, full_name string)\r\nSTORED BY 'org.apache.hadoop.hive.cassandra.CassandraStorageHandler'\r\nWITH SERDEPROPERTIES (\"cassandra.columns.mapping\" = \":key,users:full_name\" , \"cassandra.cf.name\" = \"users\")\r\nTBLPROPERTIES (\"cassandra.ks.name\" = \"ks33\");\r\n\r\nHive Query:\r\nselect * from users;\r\nalways return duplicated rows (one row appears twice)\r\nselect count(1) from users;\r\nreturn 2 but exactly I only insert one row.\r\nDo you have any idea why this happen?"}}