4 Easy Steps: Installing Google Big Query on Windows XP

Hello There!!
I am a newbie in this programming world and I faced many problems when I wanted to install Google bigquery (Big Query). As there are no guides that teach you how to do it right from the start. There are readme files provided, but for beginners, its really difficult to find a tutorial which teaches how to install bigquery from scratch. This tutorial basically deals with how to run bq shell on windows XP.
Pre-requisites:

You are required to have a Google bigQuery account.

You are required to have a Google storage account.

Step 1:
Download and Install:

a)      Go to http://www.python.org/getit/

Download the latest version. I used http://www.python.org/ftp/python/2.7.1/python-2.7.1.msi (version 2.7)

Double click and install. This is what I like about Windows system. Its such a relief to double click than type so many lines of codes. (For Linux lovers: I have a copy of Ubuntu up and running )

Note that, by default, it gets installed in C:\Python27

If you have installed in some other location, not a problem at all. But, note down the directory name.

b)      Now, you got to install the setup tools:

Go to:  http://pypi.python.org/pypi/setuptools#downloads

And download the setup tools corresponding to your version of python. In my case its 2.7.1. Cool

!!!!!

Step 2:

Now comes the type type type till you succeed part. My brother and my best friend hate me for this. I hate it when it comes to command line. When they have such a great tool, why not make it a little user friendly? We are not living in type type type age for God’s sake!!!

Alrightie rightie, open the command prompt. (Start>Programs>Accessories>Command Prompt

Or alternatively Start>Run>cmd)

You should see the following window or similar.

Now you need to go to the location of scripts of Python. To do so, simply type cd C:\Python27\Scripts

(Note: if you have installed in some other location, make sure you change the path accordingly. If you have different version of Python, make sure you type the path correctly)

Step 3:

Scratch your head,  Now nose. It doesn’t help in installation, but at present both are itching.

Type the following commands:

easy_install bigquery-shell

Word of caution here: it will grab some files and installs. At the end if you see a message that says, skipped dependencies, then you also need to install the dependencies separately.

Nothing to worry, just type in the following one by one:

easy_install google-apputils 
easy_install python-gflags 
easy_install pyreadline 

Ok. Once again type:

easy_install bigquery-shell

Step 4:

Enter  bqshell at the same prompt.

If everything goes fine, you should see the following window,

Enter your username and hit enter. It will ask for password. Note that password field will not be displayed, carefully type the password.

Voila!!!!

You will see the following window:

Type in the test lines to check if its working:

.desc bigquery/samples/shakespeare

     SELECT COUNT(*) FROM [bigquery/samples/shakespeare];

Time to dance if you see the following window:

Congratualations!!!

You have successfully run your very first bigQuery!!!

Please feel free to post your comments and installation experiences.

Welcome to Nowhere Helpline

Welcome to Nowhere Helpline

You have experienced it often. You call the helpline of cellular operator or booking office or some public utility and you are greeted by that tinny machinery voice asking you to press all the possible buttons of your handset.
This article might be monitored for quality management and may be recorded for our training program. Beep! If your both eyes are open, press 1, if your one eye is open, press 2 if your both eyes are closed, then how are you reading this? Go back and press 9.
If you wish to read in English, press 1, for Kannada press 2, for Hindi press 3, for Spanish, you are out of luck.
This article is accessible only to our registered customers; please enter your 115 digit number present at the back of this article. If you want to purchase the registration code, please press 1 and wait till our customer care executive attend to you shortly.
Thank you for your patience, press 1 if you have pet dog, press 2 if you have a pet cat. If you don't have any pets, press 3 and buy one.
If you want this article to be read to you press 1, if you want this to be read in Italian, go to Pizza Hut.
If you want to purchase this article, press 0, if you didn't like it, why are reading it? I mean press 1. If you want author of this article to write such article, press 1, if you don't want press 2, if you are fed up of this article, please don't hang up. Your call is important to us. Thank you for your patience.
If you have problem with the IA marks, press 1, if you have problem with the attendance press 2, if you have problem with the department press 3 and wait for the operator. Please do not hangup, someone will attend to you shortly. Press 4 to know how many are waiting like you.
(Chorus: Jingle bell jingle bell jingle all the way.............)
"Hello! Welcome to nowhere helpline. Thank you for your patience, may I know your good name please?"
"@#$%!"
"Hello Mr. @#$%! May I know your USN?"
"*&^%$"
"We appreciate your patience, how can I help you? You are from VTU or autonomous?"
"Autonomous"
I am sorry you have reached the VTU helpline. Please dial 56165464654616587 followed by your 15 digit registration number."
beep beep beep beep
Somebody please call the ambulance.

THE GEARS

Few of the worst hands on google search will terminate on this article in search of google gears. If you are the one, please stop reading: this is not the gears you are looking for. If you are a mechanical student and trying to find something for your project, knowledge or whatever, then its time to stop reading too. These gears are different: they are hypo-realitical (Hypothetical + Real)
Today we are discussing a system. The system has many gears. If you happen to know about gears from your high school mechanics. A gear is a component within a transmission device that transmits rotational force to another gear or device. In a layman's words, its a round disk with teeth engraved around it, with help of which it rotates or makes the similar disks rotate.
Back to our system: Our system has three type of gears. The Inner Gear, the Upper Gear and the Idle Gear.
The above mentioned three gears are part of all the systems of this world. Let the system be mechanical, electrical, electronic, biological, mathematical or for that matter universal, these three gears are present: in one form or the other. In order to understand a system, you should know these Gears well. The sooner and better you understand them, the more you know about the system. In this second bolg, I will try to make you understand the basics of these Gears.
Inner Gear: It is the most important gear of the system. None the less it makes the whole system function. Most of the time the inner gear is invisible. When this gear is invisible, you may confuse it with idle gear. You may try to meddle with it in this confusion. But, without knowing about it completely, if you interfere with it, then you wont be part of the system anymore.

The upper gear is the quite visible gear of the system. It appears that this drives the whole system, but it is just appearance. Truly, the inner gear manages even this upper gear. The purpose of the upper gear is to exhibit the outer world that the system is working. Truth to be told, this is the most deceiving gear of all. Many people get confused and regard it as inner gear. They study it, master it and believe that they have understood the system. But they fail fatally. Because, they have understood the surface, not the depth. In short, upper gear is the superficial gear which shows off the functions of the system and in maximum number of cases is driven by inner gear.

The idle gear: Many people who have understood the inner gear and upper gear wonder why do the systems keep the idle gear. But, like friction, resistance, the idle gear is the inseparable component of the system. In few of the cases we try to remove the idle gears, and later realize that they are derivatives of the inner gear. In turn we eliminate ourselves from the system. Remember: idle gear can be made less idle, but it can not be eliminated from the system. You need to adjust with the idle gear. The day you consider the idle gear as the inseparable, you will start learning the inner gear.

In this world of gears, where do you see yourself? What do you think each gear in our lives mean? What makes the inner gear most powerful? How many of us are out of many systems because we meddled with the inner gear? How many of us are unhappy with the systems because of the idle gear? How does it feel when inner gear is invisible and the outer gear takes all the credits?. And the most important: Which gear do you want to be?

All this can be answered when you master these gears.

START ROTATING? GET GEARED

THE ICE CREAM WALA

I started blogging pretty late. I think this is the right time though. My first blog is dedicated to an

"Ice cream wala".

It was a hot morning. I was leaving for Davangere. Reached the R R bus stand at around 11.30 am. These buses wait till they are full. The timings are flexible by 15 minutes. So, I sat in the bus. The hawkers keep coming in the bus to sell chats, magazines and news papers. This Ice cream wala was one of them. Of course he was selling ice creams.

He passed by me with a varieties of ice cream sticks. I was not interested in purchasing any of them, he passed by. One of the man purchased a 10 rupee stick. He had 20 rupee note. Even the vendor didn't have change. The bus started moving. He told that he will get another 10 rupee ice cream instead and the man agreed. The ice cream wala got down from the bus. The co-passengers started making fun of the man saying that how did he trust him. The bus left and almost reached the gates of the bus stand. By this time I was very much interested in knowing if he will turn up. I wasn't sure though.

To my surprise, and the surprise of everyone, the old man entered the bus puffing and panting. He handed over the ice cream and hurriedly got down from the moving bus.

There was kind of disappointment which replaced the mocking smile of the co passengers. There were few faces which were delighted. Delighted because there are still persons who are honest.