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: 严超 To: user@cassandra.apache.org Dat

Re: mysql based columnar DB to Cassandra 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://gith

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. IT

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

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: 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

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

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 &

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 Serv

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: chararray,

Re: unable to load data using sstableloader

he 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 wrote: Thanks Duncan for quick help now i am trying sstableloader but its not loading data...any suggestion ? [root@

Re: unable to load data using sstableloader

: 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 >

Re: unable to load data using sstableloader

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...@tcs.com>

unable to load data using sstableloader

Hello, I am unable to load sstable into cassandra using sstable loader, please suggest. Thanks. [root@CSL-simulation conf]# pwd /root/Akshay/Cassandra/apache-cassandra-2.0.8/conf [root@CSL-simulation conf]# ls -ltr keyspace/col/ total 32 -rw-r--r-- 1 root root 16 Jul 28 16:55 Test-Data-jb-1-Fil

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: CSV Import is taking huge time

.org/jira/browse/CASSANDRA-7405. Currently cqlsh's COPY FROM just uses a single-threaded for-loop with synchronous inserts. On Wed, Jul 23, 2014 at 8:09 AM, Jack Krupansky wrote: Is it compute bound or I/O bound? What does your cluster look like? -- Jack Krupansky From: Akshay Ba

Re: CSV Import is taking huge time

onsulting From: "Jack Krupansky" To: 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: Wednesday, July 23, 20

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 101,1,2,3,4,5,6,7,8,9,10,11,12,13,14

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 se