Well, I'm new here but I can point you to the docs as well as old timers probably. First, I think the developers would prefer that you only direct questions like this to the users list, not to both. Other answers are inline below:
On Thu, Apr 7, 2011 at 12:00 AM, komara nagarjuna <komaranagarj...@gmail.com> wrote: > > In Hive, I create a table successfully.My problem is how to insert data > to hive tables. I can only assume you've not found the documentation on the Wiki. There is a big section that covers "loading data" here: http://wiki.apache.org/hadoop/Hive/Tutorial and a section called DML operations here: http://wiki.apache.org/hadoop/Hive/GettingStarted I would also highly suggest going through the video tutorial on Cloudera's site related to Hadoop, HDFS, and Hive available here: http://www.cloudera.com/resources/?type=Training which is all free. You may really want to consider buying the Hadoop book from O'Reilly http://www.amazon.com/Hadoop-Definitive-Guide-Tom-White/dp/1449389732/ref=sr_1_1?ie=UTF8&qid=1302174753&sr=8-1 I've read it (nearly) cover to cover and it is a great resource. There is one chapter on Hive, but also good real world cases of how Hadoop and Hive are being used. The facebook example is very instructive on practical use of Hive. > How to communicate Hadoop with Hive. I'm not sure I understand the question. Hive of course uses Hadoop natively, and you'll see documented above examples of how to load data from HDFS if it is already there. > How to use Hive datawarehouse. > What is the purpose of hive. These questions are too general to really answer, except that you use the "SQL-like" language of HQL to run queries, or you may want to use a related project like Sqoop to extract data out to another database for use building a datamart or loading into a cube for use in a more traditional (and untrained analyst-friendly) tool. > Please explain how to use Hive in real time. If by real time you mean incremental inserts, or very low latency queries, you need to especially see the "What Hive is NOT" section of this page: http://wiki.apache.org/hadoop/Hive Hope that helps, Geoff
