java - creating column family in cql? -


when create column family using cql gives me unexpected output.

public static void createcolumnfamily() { try { class.forname("org.apache.cassandra.cql.jdbc.cassandradriver"); connection con = drivermanager.getconnection("jdbc:cassandra://192.168.1.32:9160/temp"); string qry = "create table users(user_name varchar," + "password varchar," + "gender varchar," + "session_token varchar," + "birth_year bigint," + "primary key (user_name)" + ")"; statement smt = con.createstatement(); smt.executeupdate(qry); system.out.println("table(column family) created"); con.close(); } catch(exception e) { system.out.println(" : " + e.getmessage()); } }

here got : line 1:132 extraneous input ')' expecting eof

you're using cql 2, not support style of primary key declaration. if want declare way, should using cql 3, can accomplish requesting version in connection url:

drivermanager.getconnection("jdbc:cassandra://192.168.1.32:9160/temp?version=3.0.0");

however, cql 3 isn't necessary this. steve van opstal suggested, can put primary key marker column definition itself, since don't have multi-component primary key.

create table users( user_name varchar primary key, password varchar, gender varchar, session_token varchar, birth_year bigint, );

cql 3 preferred if cassandra supports it, way forward, in case don't want switch right now, can make second change.


Comments

Post a Comment

Popular posts from this blog

javascript - backbone.js Collection.add() doesn't `construct` (`initialize`) an object -

<!doctype html public "-//w3c//dtd xhtml 1.0 strict//en" "http://www.w3.org/tr/xhtml1/dtd/xhtml1-strict.dtd"> <html> <head> <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.7.2/jquery.min.js"></script> <script src="http://documentcloud.github.com/underscore/underscore-min.js"></script> <script src="http://documentcloud.github.com/backbone/backbone-min.js"></script> </head> <body> <button id="cmd_create_event" name="cmd_create_event" type="button">create new `event`</button> <script type="text/javascript"> var eventmodel = backbone.model.extend({ initialize : function() { console.log("`event` initialized. id: " + this.cid); this.bind("change:status", function() { console.log(this.get("status") + " value `status`"); }); this.bind("error", function(model, e...
Read more

php - Get uncommon values from two or more arrays -

is there function in php give array of uncommon values 2 or more arrays? for example: $array1 = array( "green", "red", "blue"); $array2 = array( "green", "yellow", "red"); .... $result = function_needed($array1, $array2,...); print_r($result); should give output: array("blue", "yellow", ...); use array_diff , array_merge : $result = array_merge(array_diff($array1, $array2), array_diff($array2, $array1)); here's demo. for multiple arrays, combine callback , array_reduce : function unique(&$a, $b) { return $a ? array_merge(array_diff($a, $b), array_diff($b, $a)) : $b; } $arrays = array( array('green', 'red', 'blue'), array('green', 'yellow', 'red') ); $result = array_reduce($arrays, 'unique'); and here's demo of that.
Read more

Adding duplicate array rows in Php -

i create function in php adds rows of array shared column value. so input. $test = array( array("c", 5, 6), array("c", 2, 3), array("test", 5, 6) ); and output. $testduplicatefree = array( array("c", 7, 9), array("test", 5, 6) ) ); i'm thinking function combine_duplicates($array,$col){ ... ... return $duplicatefreearray; } where $col duplicate free array. so, in case, combine_duplicates($test,0); would me desired output. this. <?php function combine_duplicates($array,$col) { $index = array(); foreach ($array $row) { $key = $row[$col]; if (!isset($index[$key])) { $index[$key] = $row; } else { ($i = 0; $i < count($row); ++$i) { if ($i != $col) { $index[$key][$i] += $row[$i]; } } } } return array_values($index); } $array = array( array("c", 5, 6), array("c", 2, 3), array("test", 5, 6) ); print_r(combine_duplicates($array, 0)); try here: http://codepad.org/mdhesqhi
Read more