Loading Binary files in Cassandra DB

Hello Team, I am going to use Cassandra DB in our existing project as its suiting my requirement. I have binary files generated from our application every one minutes and have to store them in DB. I have a table which is having 100+ column on which customer is going to use only 10 column for

CSV Import is taking huge time

Hello, I am trying copy command in Cassandra to import CSV file in to DB, Import is taking huge time, any suggestion to improve it? id,a,b,c,d,e,f,g,h,i,j,k,l,m,n,o,p,q,r,s,t,u,v,w,x,y,z 100,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26

Re: CSV Import is taking huge time

From: Jack Krupansky j...@basetechnology.com To: user@cassandra.apache.org Date: 07/23/2014 06:39 PM Subject: Re: CSV Import is taking huge time Is it compute bound or I/O bound? What does your cluster look like? -- Jack Krupansky From: Akshay Ballarpure Sent

Re: CSV Import is taking huge time

Krupansky From: Akshay Ballarpure Sent: Wednesday, July 23, 2014 5:00 AM To: user@cassandra.apache.org Subject: CSV Import is taking huge time Hello, I am trying copy command in Cassandra to import CSV file in to DB, Import is taking huge time, any suggestion to improve it? id,a,b,c,d,e,f,g,h

read huge data from CSV and write into Cassandra

How to read data from large CSV file which is having 100+ columns and millions of rows and inserting into Cassandra every 1 minute. Thanks Regards Akshay Ghanshyam Ballarpure Tata Consultancy Services Cell:- 9985084075 Mailto: akshay.ballarp...@tcs.com Website: http://www.tcs.com

Re: unable to load data using sstableloader

should be created before you load these data file to C*. Here is the article for introduction of sstableloader that you could refer. http://www.datastax.com/documentation/cassandra/1.2/cassandra/tools/toolsBulkloader_t.html On Mon, Jul 28, 2014 at 7:28 PM, Akshay Ballarpure akshay.ballarp

Re: unable to load data using sstableloader

12:58 PM Subject: Re: unable to load data using sstableloader Hi Akshay, On 29/07/14 09:14, Akshay Ballarpure wrote: Yes, I have created keyspaces, but still i am getting error. cqlsh:sample_new DESCRIBE KEYSPACES ; system sample mykeyspace test *sample_new* system_traces [root@CSL

Re: unable to load data using sstableloader

being run on the same host as the Cassandra node 127.0.0.1 (I see your ring is made up of all loop back IPs). Rahul Neelakantan 678-451-4545 On Jul 29, 2014, at 4:55 AM, Akshay Ballarpure akshay.ballarp...@tcs.com wrote: Thanks Duncan for quick help now i am trying sstableloader but its

Cassandra - Pig integration

Hello, I am trying to integrate cassandra into Hadoop and PIG and trying to load CSV file into Cassandra using PIG Script. Can someone help ? root@hadoop-1:/home/hduser/apache-cassandra-2.0.9/examples/pig# cat pigCasandra.pig data = LOAD 'example.csv' using PigStorage(',') AS (row_id:

Re: adding more nodes into the cluster

Is there any good documentation for multi node clustering ? Thanks Regards Akshay Ballarpure Tata Consultancy Services Cell:- 9985084075 Mailto: akshay.ballarp...@tcs.com Website: http://www.tcs.com Experience certainty. IT Services

cassandra JDBC driver required

) at java.net.URLClassLoader.findClass(URLClassLoader.java:354) at java.lang.ClassLoader.loadClass(ClassLoader.java:425) at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308) at java.lang.ClassLoader.loadClass(ClassLoader.java:358) ... 5 more Thanks Regards Akshay

PHP - Cassandra integration

Hello, I am working on PHP cassandra integration, please let me know which library is good from scalability and performance perspective ? Best Regards Akshay Ballarpure Tata Consultancy Services Cell:- 9985084075 Mailto: akshay.ballarp...@tcs.com Website: http://www.tcs.com

Re: PHP - Cassandra integration

Thanks Robert for quick reply. Please let me know where is software and documentation located ? Best Regards Akshay Ballarpure Tata Consultancy Services Cell:- 9985084075 Mailto: akshay.ballarp...@tcs.com Website: http://www.tcs.com Experience

mysql based columnar DB to Cassandra DB - Migration

I have one mysql based columnar DB, i want to migrate it to Cassandra. How its possible ? Best Regards Akshay Ballarpure Tata Consultancy Services Cell:- 9985084075 Mailto: akshay.ballarp...@tcs.com Website: http://www.tcs.com

Re: mysql based columnar DB to Cassandra DB - Migration

Hello Folks, I have one mysql based columnar DB, i want to migrate it to Cassandra. How its possible ? Best Regards Akshay Ballarpure Tata Consultancy Services Cell:- 9985084075 Mailto: akshay.ballarp...@tcs.com Website: http://www.tcs.com Experience

RE: mysql based columnar DB to Cassandra DB - Migration

Thanks Andy for quick reply. I will have a look at the below link and get back. Best Regards Akshay Ballarpure Tata Consultancy Services Cell:- 9985084075 Mailto: akshay.ballarp...@tcs.com Website: http://www.tcs.com Experience certainty

Re: mysql based columnar DB to Cassandra DB - Migration

DB - Migration On Wed, Nov 26, 2014 at 2:15 PM, Akshay Ballarpure akshay.ballarp...@tcs.com wrote: Hello Folks, I have one mysql based columnar DB, i want to migrate it to Cassandra. How its possible ? see if Troop[1] helps, it was only tested with mysql 5.x and Cassandra 2.0.10 [1] https

Re: [Import csv to Cassandra] Taking too much time

Hello Chao Yan, CSV data import using Copy command in cassandra is always painful for large size file (say 1Gig). CQL tool is not developed for performing such heavy operations instead try using SSTableLoader to import. Best Regards Akshay From: 严超 yanchao...@gmail.com To: