That's exactly what I was looking for!
Thanks!
On Fri, May 11, 2012 at 5:34 PM, David Kulp dk...@fiksu.com wrote:
You're right. I assumed there was a corresponding ALTER TABLE foo SET ROW
FORMAT ...
But I found the answer in the archives. Modify the SERDE properties, e.g.
SET
Hi all
I create index on hbase faild .
This is my sql. How to create index on HBase?
create index i_hhive on hhive(c1,c2) as compact with deferred rebuild STORED
BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
WITH SERDEPROPERTIES (hbase.columns.mapping =
:key,cf1:val,cf1:val2,cf1:val3)
May be you can see razorsql to convert schemas.
---
Sent from Mobile , short and crisp.
On 12-May-2012 11:58 AM, Xiaobo Gu guxiaobo1...@gmail.com wrote:
**
I can't find it in the release package.
--
Xiaobo Gu
Hi,
I put mysql-connector-java-5.1.20-bin.jar into $HIVE_HOME/lib, and
configurations in hive-site.xml are
property
namejavax.jdo.option.ConnectionURL/name
valuejdbc:mysql://192.168.72.1:3306/hive/value
descriptionJDBC connect string for a JDBC metastore/description
/property
property
property
namejavax.jdo.option.ConnectionURL/name
valuejdbc:mysql://
192.168.72.1:3306/hive?createDatabaseIfNotExist=true/value
descriptionJDBC connect string for a JDBC metastore/description
/property
If it doen't work, show the log in
I am sorry, I forget starting hadoop first, but the error messages are
confusing too :)
Xiaobo Gu
From: ransom.hezhiqiang
Date: 2012-05-12 15:46
To: user@hive.apache.org; 'guxiaobo1982'
Subject: RE: Where should I put JDBC drivers for metastore service
property
Hi all
I create index on hbase faild .
This is my sql. How to create index on HBase?
create index i_hhive on hhive(c1,c2) as compact with deferred rebuild STORED
BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
WITH SERDEPROPERTIES (hbase.columns.mapping =
:key,cf1:val,cf1:val2,cf1:val3)
Hive can auto create metadata tables, maybe you can try it out.
On Sat, May 12, 2012 at 2:28 PM, Xiaobo Gu guxiaobo1...@gmail.com wrote:
I can't find it in the release package.
Xiaobo Gu
Hi Xiaobo,
It depends on what your current setup is:
a) If you are trying Hive for the first time, then you don't necessarily
need to create schema in postgres upfront. As wd suggested, datanucleus
(ORM used by Hive) can autocreate the schema if it doesn't exist.
b) If you are already using Hive
Hi everyone,
I must say I'm only starting, and this is on cdh3u3.
I'm struggling with the sqoop options ATM, trying to import mysql tables
to hive, containing tabs, newlines, and all sorts of things.
I cannot figure out a proper combination of options on the sqoop command
line to turn these
Hi David,
A typical MySQL import will look like:
$ sqoop import --connect jdbc:mysql://localhost/mydb --username user
--password pswd --table mytable
Depending upon what you are trying to do and the datatypes that you have in
your MySQL table, you may have to provide different options. If you
In hive, the raw data is in HDFS and there is a metadata layer that defines
the structure of the raw data. Table is usually a reference to metadata,
probably in a mySQL server and it contains a reference to the location of
the data in HDFS, type of delimiter or serde to use and so on.
1. With hive
Indexes can be built on tables managed by hive. For external tables I do not
believe that to be true. Please feel to correct if I am wrong.
Thanks,
Ranjith
On May 12, 2012, at 9:24 PM, Nanda Vijaydev nanda.vijay...@gmail.com wrote:
In hive, the raw data is in HDFS and there is a metadata
13 matches
Mail list logo
