AdSenseHeader

Step By Step Guide to install Cassandra and Cqlsh on Windows


  Today I started to play with Cassandra by installing it in my windows machine. When I am installing Cassandra in windows I faced some issues. So I thought to share this information.


Step1: Download Cassandra from http://cassandra.apache.org/download/. The current latest version                 is  2.0.1. It is a tar.gz file. Download and extract it in some location in your computer.
              For example you can extract D:\cassandra ..

             If you are using  cassandra 2.0.1 you must use the java1.7.If you are using cassandra                    earlier versions java1.6 is enough

Step 2: You should set the path of JAVA in SystemVariables.
              For Example Java_Home=C:\Program Files (x86)\Java\jre1.7.0
             And also set the Cassandra_Home=D:\cassandra;
           

Step 3:  Go to your cassandra conf folder.For example D:--->cassandra-->conf
             Change the cassandra.yaml file like fallows
               1) In the line of  #commitlog content into changed your extracting cassandra path.For                               Example as fallows
                 # commit log
                     commitlog_directory: d:/cassandra/commitlog 
and create a directory cassandra                                      named as commitlog..
             2) In the line of data_file_directories changed like fallows
                           data_file_directories:
                                    - d:/cassandra/data
                       and create a directory(folder) named as data...

Step 4:  You can start cassandra server by calling cassandra.bat available with in the                                         bin  directory.When server starts its shows like fallows
           
             



 Step 5: Now to interact with Cassandra database you need the cqlsh interactive command tool.              Here is the small twist. There is none in the cassandra download package. So there                    is a work around we should do before adding records to the database.

Step 5: Download python from the below location http://www.python.org/download/releases/. Be careful here. Though the python latest version is 3.x, there is problem with installing thrift library with the latest version of Python. So download and install 2.7 version of Python.

Step 6: Next install the PYTHON in your system.And set the path of Python in path variable.

Step 7: Now you can go to cassandra bin folder then run CQLSH.Now you connect to cassandra and create the keyspace and tables.

  • CREATE KEYSPACE mykeyspace WITH REPLICATION = { 'class' : 'SimpleStrategy', 'replication_factor' : 1 }; 
  • Use mykeyspace.
  • create table sample(id int primary key,name text ,desg text);





      









10 comments:

  1. can u tell how to start cassandra server

    ReplyDelete
  2. This is good information. It helped me to setup the tar.gz of cassandra and cqlsh. I dont know why thrift installation instruction is not provided in apache getting started wiki page.

    ReplyDelete
  3. It's really worth reading the blog post whcih has useful content. I have recently done CRS Info Solutions which is highly helpful to upgrade my career. What is the Salesforce course training fee in Chennai? Which is the best option from Salesforce training in Chennai? Who offers job oriented Salesforce training in Chennai? Find the best institute for project based Salesforce training in Chennai.

    ReplyDelete
  4. You can join the free orientation at Workday training institutes in Bangalore and they located at Workday training institutes in delhi. It is highly recommendable for you to enroll at Workday training institutes in UK and you can have a great market for jobs in USA so join this wonderful Workday training institutes in USA and in India this Workday training institutes in Noida is really best institute.

    ReplyDelete
  5. Myself so glad to establish your blog entry since it's actually quite instructive. If it's not too much trouble continue composing this sort of web journals and I normally visit this blog. Examine my administrations.
    Go through these Salesforce Lightning Features course. Found this Salesforce CRM Using Apex And Visualforce Training worth joining. Enroll for SalesForce CRM Integration Training Program and practice well. 

    ReplyDelete
  6. Crypto-currency as a modern form of the digital asset has received a worldwide acclaim for easy and faster financial transactions and its awareness among people have allowed them to take more interest in the field thus opening up new and advanced ways of making payments. Crypto.com Referral Code with the growing demand of this global phenomenon more,new traders and business owners are now willing to invest in this currency platform despite its fluctuating prices however it is quite difficult to choose the best one when the market is full. In the list of crypto-currencies bit-coins is one of the oldest and more popular Crypto.com Referral Code for the last few years. It is basically used for trading goods and services and has become the part of the so-called computerized block-chain system allowing anyone to use it thus increasing the craze among the public, Crypto.com Referral Code.

    Common people who are willing to purchase BTC can use an online wallet system for buying them safely in exchange of cash or credit cards and in a comfortable way from the thousands of BTC foundations around the world and keep them as assets for the future. Due to its popularity, many corporate investors are now accepting them as cross-border payments and the rise is unstoppable. With the advent of the internet and mobile devices,information gathering has become quite easy as a result the BTC financial transactions are accessible and its price is set in accordance with people’s choice and preferences thus leading to a profitable investment with Crypto.com Referral Code Code. Recent surveys have also proved that instability is good for BTC exchange as if there is instability and political unrest in the country due to which banks suffer then investing in BTC can surely be a better option. Again bit-coin transaction fees are pretty cheaper and a more convenient technology for making contracts thus attracting the crowd. The BTC can also be converted into different fiat currencies and is used for trading of securities, for land titles, document stamping, public rewards and vice versa.

    Another advanced block-chain project is Ethereumor the ETH which has served much more than just a digital form of crypto-currency Crypto.com Referral Code and its popularity in the last few decades have allowed billions of people to hold wallets for them. With the ease of the online world,the ETH have allowed the retailers and business organizations to accept them for trading purposes, therefore, can serve as the future of the financial system.

    ReplyDelete
  7. Our full Lace Front Wigs are all hand made with a lace cap. They are manufactured with thin lace sewn on top of the cap. Individual hairs are then sewn onto the thin lace. Each lace wig has lace all around the unit which will need to be cut prior to securing the wig to your head. You will need to cut along the hairline around your entire head. By doing so, you will be able to wear your hair anyway you like. You can even style ponytails, up-dos, etc. Once the Lace Wigs is successfully applied, it will appear that all the hair is growing directly from your head!

    Lace front wigs are hand-made with lace front cap & machine weft at back. Lace front wigs are manufactured with a thin lace that extends from ear to ear across the hairline. When you receive the wig, the lace will be quite long in the front. Cut and style according to your preference, as you will need to apply adhesive along the front of the wig. Once the wig is applied, you will still have Lace Wigs with a very natural appearance.
    TeamWigz Provide the Best Lace Front Wigs and Lace Wigs in Johannesburg and South Africa.

    ReplyDelete
  8. If you live in Los Angeles and need Washer Repair Service Los Angeles, we are the company to call. We have years of experience repairing all makes and models of washer. Our service is fast, effective and affordable. Plus, we stand behind our work. If you want to make sure your washer is functioning at optimal efficiency, call us. We will be there in a flash and can quickly solve any problem you are having with your washer. Whether you have an older model washer or one of the latest, high-tech ones, we can get it working in a flash. We have long provided the washer repair Los Angeles residents need.

    No matter what type of washer problem you are having, we can help. We can fix your washer if it won’t start, stopped spinning, won’t stop, is making strange noises, tripping the breaker, the drum isn’t turning or any other issue.

    We have a team of well-trained, highly skilled technicians with many years of experience repairing Washer Repairs in Los Angeles of all types. Our technicians are licensed, bonded and insured. Plus they are prompt, courteous, friendly and professional. They have the tools and expertise necessary to identify and repair any problem you are having with your washer. They will let you know if the problem is a part that is worn or broken and if the part needs to be repaired or replaced. They will let you know what the job will cost in advance, so you will not have any surprises when the work is done.

    We charge some of the lowest prices in the industry. We do a volume business, so we buy our replacement parts in bulk and pass the savings on to you. Plus, we only use quality replacement parts, so you can rest assured you are getting great value for your money. We will let you know if it will cost less and be just as sturdy if we repair or replace any part that is worn or broken. That gives you the power to decide what it will cost to get your washer working and keep it working for a long time to come.

    ReplyDelete
  9. If you live in Los Angeles and need Refrigerator Repair Service Los Angeles, we are the company to call. We have years of experience repairing all makes and models of refrigerator. Our service is fast, effective and affordable. Plus, we stand behind our work. If you want to make sure your refrigerator is functioning at optimal efficiency, call us. We will be there in a flash and can quickly solve any problem you are having with your refrigerator. Whether you have an older model refrigerator or one of the latest, high-tech ones, we can get it working in a flash. We have long provided the refrigerator repair Los Angeles residents need.

    No matter what type of refrigerator repair problem you are having, we can help. We can fix your refrigerator if it won’t start, stopped cooling, won’t stop, is making strange noises, tripping the breaker, the compressor isn’t turning or any other issue.

    We have a team of well-trained, highly skilled technicians with many years of experience repairing refrigerator of all types. Our technicians are licensed, bonded and insured. Plus they are prompt, courteous, friendly and professional. They have the tools and expertise necessary to identify and repair any problem you are having with your refrigerator. They will let you know if the problem is a part that is worn or broken and if the part needs to be repaired or replaced. They will let you know what the job will cost in advance, so you will not have any surprises when the work is done.

    We charge some of the lowest prices for Refrigerator Repair Los Angeles in the industry. We do a volume business, so we buy our replacement parts in bulk and pass the savings on to you. Plus, we only use quality replacement parts, so you can rest assured you are getting great value for your money. We will let you know if it will cost less and be just as sturdy if we repair or replace any part that is worn or broken. That gives you the power to decide what it will cost to get your refrigerator working and keep it working for a long time to come.

    ReplyDelete
  10. Are you searching for the perfect Appliance Repair Los Angeles? Did your appliance break down, and you need a qualified and experienced technician to fix it? Do not search any further; we do appliance repair Los Angeles, California. We are your one-stop shop for the highest possible quality Appliance Repair Los Angeles, Dryer Repair Los Angeles, Washer Repair Los Angeles, Refrigerator Repair Los Angeles, Dishwasher Repair Los Angeles and stove Repair Los Angeles and Oven Repair Los Angeles. We provide top-of-the-line appliance repair Los Angeles to cater to your damaged appliance as soon as possible. Our priority is the satisfaction of our clients. We draw from our more than 15 years of experience and updated technical knowledge to offer the best appliance repair Los Angeles, dryer repair Los Angeles, washer repair Los Angeles, refrigerator repair Los Angeles, dishwasher repair Los Angeles, and stove and Oven Repair Los Angeles. As a reputable repair company, we work hard to fulfill our corporate goals.

    You are assured of the best dishwasher repair Los Angeles when you hire us to repair your broken dishwasher. Your dishwasher may leave dirty or oily residues on your dishes. It may even develop electrical faults making it non-operational. Also, if your dishwasher is leaking water to the floor, call us. You should contact us immediately; we will come there directly and fix your appliance.

    We know how inconvenient it can be living with a broken refrigerator. Irrespective of the model of your refrigerator, we will help you to repair it correctly. Our technicians are among the best you can find in Los Angeles. So, we guarantee the best repair service that will make your refrigerator work perfectly and last longer. When your refrigerator runs out of gas, and it does not cool any longer, contact us through our hotlines. We will fix your refrigerator, and you will be glad.

    We Are a Factory Trained Approved And Professional Appliance Repair Company Dedicated to Providing Top-Of-The-Line Appliance Repair to Residents in the Entire Los Angeles Area & Surrounding Areas. Call Us Today!

    ReplyDelete

 
Top