Re: Basic statement problems

2012-03-09 Thread Keith Wiley
So a directory, not a specific file. I thought I tried it both ways, but I'll switch it back the other way and try again. Thanks. On Mar 9, 2012, at 16:46 , Steven Wong wrote: > The LOCATION clause has to specify the directory that contains (only) your > data files.

Re:RE: Basic statement problems

2012-03-09 Thread 王锋
support that location must be your data directory. At 2012-03-10 08:46:01,"Steven Wong" wrote: >The LOCATION clause has to specify the directory that contains (only) your >data files. > >-Original Message- >From: Keith Wiley [mailto:kwi...@keithwiley.com] >Sent: Friday, March 09, 2012 3

RE: Basic statement problems

2012-03-09 Thread Steven Wong
The LOCATION clause has to specify the directory that contains (only) your data files. -Original Message- From: Keith Wiley [mailto:kwi...@keithwiley.com] Sent: Friday, March 09, 2012 3:44 PM To: user@hive.apache.org Subject: Basic statement problems I successfully installed and used Hi

0.7.1 vs. 0.8.1

2012-03-09 Thread Keith Wiley
The only version feature list I have found so far is the JIRA logs, which are a little difficult to make sense of since they get pretty detailed. I'm curious from a straight-forward high-level "sales-pitch" perspective what advantages 0.8.1 offers over 0.7.1. I ask because I generally use CDH3

Basic statement problems

2012-03-09 Thread Keith Wiley
I successfully installed and used Hive to create basic tables (on one of my two machines; another discussion describes the problems I'm having with the other machine). However, basic queries aren't working. I brought a typical CSV file into a Hive table and it seemed fine. Here's how I did it

Re: Error

2012-03-09 Thread Keith Wiley
Considering that I don't even konw what the metastore is, I doubt I did anything specifically aside from the instructions. All I did was follow the startup guide. Nothing more. More to the point, when I followed the same instructions on a Linux box, it worked. Something is admittedly wrong w

Re: Error

2012-03-09 Thread Mark Grover
Hi Keith, This error is typically encountered when your metastore (that stores the metadata related to Hive tables e.g. name of columns, name of tables, etc. etc.) is not correctly set up. Have you set up an external metastore? By default, Hive should use an embedded Derby metastore which only

Error

2012-03-09 Thread Keith Wiley
I'm quite comfortable hadoop and the associated lingo, been programming it via Java and via C++ streams for several years. However, I have just started Hive for the first time...and I'm stuck. I was following the "getting started" page on the apache site. I got a far as this: hive> CREATE TA

Re: Hive-645 is slow to insert query results to mysql

2012-03-09 Thread Bejoy Ks
Hi Wei      +1 to Viral's comments. We have implemented quite a few production systems that uses SQOOP to do the data transfer between hdfs and jdbc compliant databases. Go for it as it is an awesome tool. You can find the usage instructions on SQOOP developer guide at http://archive.cloudera.com

RE: Hive-645 is slow to insert query results to mysql

2012-03-09 Thread Viral Bajaria
Hey Wei, I have used the udf before and figured it is only useful for summary results and not for big datasets due to the fault tolerant nature of map/reduce. If you don't have a well defined primary key you will end up with more rows than your query results. And you are correct in saying that thi