Stack Overflow
Stack Overflow

Questions tagged [cassandra-cli]

The Cassandra CLI is a holdover from the pre-CQL Thrift API.

166 questions
0
votes
3 answers

How do I get all the keys that are stored in the Cassandra 2.0.1 column family with scala using hector?

I have to enter some values with a key(suppose key1="1_100"), but before inserting the values i want to check that is key("1_100") is already inserted or not.I know it will replace the previous one, if exists. i only want to enter values if key is…
user2822316
0
votes
0 answers

Get updated column in Cassandra using Hector Api

I am using scala with play framework. I've just started cassandra with Hectors. I have a function to delete a comparator of given key. But I want to know if comparator is actually deleted or not. Here is my function... def delete()={ var…
Ravi
  • 182
  • 3
  • 18
0
votes
1 answer

how to insert system date and time through Command Line interface of cassandra in windows

I am new to cassandra. I want to know how can i insert system date and time through CLI (command line interface) for perticular row. DateType and TiemUUIDType are just data types for this purpose so how can i use this two data types and insert the…
Helping Hand..
  • 2,430
  • 4
  • 32
  • 52
0
votes
1 answer

How to create composite primary key in cassandra using CLI?

i try to make composite primary key using cassandr-CLI but i'm unable to do that, i am able to do that using Cqlsh. can you help me out?
user2888996
  • 417
  • 8
  • 20
0
votes
1 answer

create Composite-keyed Table with cassandra-cli

i want to use php for my project with phpcassa which doesn't support cql, so if I understood right I have to code cassandra commands like I would with cassandra-cli. My question is how can I create a Composite-keyed Table or Dynamic Column…
user1072680
0
votes
1 answer

error when cassandra-cli command executed in ssh

I have two servers A and B, I have a shell script in serverA which logs into serverB (through ssh) and runs the following command: sh cassandra-cli -h -v -f database_import.txt; so when I do this manually, I follow these steps: serverA:~$…
Uday Reddy
  • 1,337
  • 3
  • 16
  • 38
0
votes
1 answer

json2sstable cassandra gives jvm error

I am using the Cassandra 1.2.8. I wanted to try the json2sstable functionality. I have created the key space "testloader" and column family symcfgTest. I already did sstable2json from one of the column family. I wanted to add those json to another…
Vishrut Shah
  • 41
  • 1
  • 4
0
votes
1 answer

Running PIG scripts on Cassandra Table

I am using Cassandra-1.2 with patch 5234 - Table created through CQL3 are not accessible to Pig Hadoop - 1.1.2 pig 0.11.1 I have a table in Cassandra datatypetest (num int PRIMARY KEY, ascii ascii, blob blob, text text, varnum varint); and the test…
rozar
  • 1,058
  • 3
  • 15
  • 28
0
votes
0 answers

Inserting current time to Cassandra using cassandra-cli?

I'm trying to insert a time value to my Cassandra column family using this command. set User['1234']['lastUpdated']='2013-07-18T10:10:00.000Z'; I've created my column family as follows: create column family User with comparator=UTF8Type and…
Halley
  • 521
  • 10
  • 35
0
votes
2 answers

Fetch string from Hector QueryResult object

I am using Java Hector API to retrieve data from Cassandra databse as following: public static void retrieveData() { try { //Create a cluster object from your existing Cassandra cluster Cluster cluster =…
Ryan Malhotra
  • 305
  • 2
  • 4
  • 13
0
votes
1 answer

Unable to insert data in cassandra-cli

Getting cassandra error: cannot parse uuid as hex bytes` java.sql.SQLSyntaxErrorException: cannot parse '8768c481-a118-48b7-aed2-2903b917d045' as hex bytes at…
Shalu
  • 251
  • 2
  • 4
  • 15
0
votes
2 answers

cassandra-cli and setting an Integer row key - getting syntax error

I created a cassandra column family that looks like the following: CREATE COLUMN FAMILY foo WITH comparator= UTF8Type AND key_validation_class=IntegerType AND column_metadata=[{column_name: bar_user_key, validation_class:…
randombits
  • 47,058
  • 76
  • 251
  • 433
-1
votes
1 answer

Cassandra column family displays differently through CLI and DataStax

I'm trying to understand why I'm seeing different data in two ways to display Cassandra (1.2.x) column family columns. In the first, I use cassandra-cli to list the rows in a column family. [cassandra-cli]> list Users columns 1; Using default limit…
Sotirios Delimanolis
  • 274,122
  • 60
  • 696
  • 724
-2
votes
1 answer

Cassandra - Do we have any thing similar to MySQL %like%?

I have a table and data as shown below, I want to query records containing owner. Any help please ? select name from team where blob like %owner% CREATE TABLE ipl.team( name text, captain text, blob text, PRIMARY KEY (name,…
abhishek kurasala
  • 295
  • 1
  • 3
  • 6
-3
votes
1 answer

how many partition key for a Cassandra table?

partition key for a Cassandra table? In customer table customerid is partition key? Suppose I have 1 million customers in year so I have 1 million partitions After 10 years so I have 10 million customers or more also ... so I have 10 million…
rakesh bud
  • 1
  • 1
1 2 3
…
11
12