iki.apache.org/hadoop/Hive/HiveClient
>
> hope that helps.
> good luck!
>
>
> On Tue, Jun 14, 2011 at 4:45 AM, jinhang du wrote:
>
>> Hi all,
>>
>> I want record the output of every commends executed on hive console
>> client.
>> How to do it ?
>>
>> Thanks.
>>
>> --
>> dujinhang
>>
>
>
--
dujinhang
from a join b on (a.s=b.s) select a.p, b.p
When I use console client, this query is well executed.
2011/6/15 Shouguo Li
> what query did u run?
>
>
> On Tue, Jun 14, 2011 at 4:49 AM, jinhang du wrote:
>
>>
>> Hi all, I use hive java client to execute hql.
>&g
Hi all, I use hive java client to execute hql.
Simple queries like 'select * from table' are answered well.
However, when i use join in my query ,exceptions occur.
Error log :
java.lang.NoClassDefFoundError:
org/codehaus/jackson/map/JsonMappingException
at
org.apache.hadoop.hive.ql.exec.ExecD
Hi all,
I want record the output of every commends executed on hive console client.
How to do it ?
Thanks.
--
dujinhang
As far as I know，
1. The external table does not need to copy data from hdfs to your warehouse
when loading data.
2. "Location" locates the data in hdfs and it links data to the table. And
when you drop table, data is not deleted.
3. The tables' information is stored in your metastore, ie derby, my
How does the columns in the table match the "input.regex" ?
In other words, which part of the regex matches the columns of the table?
Will anybody offer some help?
2011/5/30 YUYANG LAN
> hi, how about this ?
>
> (.+)&&&(.+?)(?:\^\^.*)?
>
> On Mon, May 3
quot;
>
>
>
> *
> *
>
>
> -- Original --
> *From: * "jinhang du";
> *Date: * Mon, May 30, 2011 05:07 PM
> *To: * "user";
> *Subject: * Question about create hive tables.
>
> My data form
My data format is as follows:
a&&&b
c&&&b^^xyz
c&&&d^^hdo
create table f(str1 string, str2 string) ROW FORMAT SERDE
'org.apache.hadoop.hive.contrib.serde2.RegexSerDe'
With SERDEPROPERTIES (
"input.regex"="(.+)&&&(.+)(\^\^.+)?"
)
My aim is :
a b
c b
c d
However ,
a b
c b^^xyz
c d^^hdo
So how to
Hi all,
I want to create external tables, and the location should be a directory in
HDFS.
How could I specify several not all files in this directory to be stored
into the table?
Thanks.
--
dujinhang
expression?
Thanks.
在 2011年5月27日 下午11:21，bangbig 写道：
> Check the log file, you can find more information about the error. The log
> file could be found from the URL given below.
>
>
> At 2011-05-27 20:07:17，"jinhang du" wrote:
>
> Are there any documents to he
xSerDe'
> With SERDEPROPERTIES (
> "input.regex"="(\\d+)&&&&(\\d+)&&&&(\\d+)"
> )
> LOCATION '/path1;
>
>
> 2011/5/25 jinhang du
>
>> Hi all，
>>
>> I want to custom the delimiter of the table in a
So what's the difference between a embedded server and a standalone server?
Can you help me understand it?
2011/5/26 김영우
> See,
> http://wiki.apache.org/hadoop/Hive/HiveClient
>
> <http://wiki.apache.org/hadoop/Hive/HiveClient>- Youngwoo
>
>
> 2011/5/26 jinhang
Hi all,
I want to create a lot of tables and load data separately. These tables need
different parameters.
So I want to use python for example, to invoke the command line client. How
to do it?
My hive runs in embedded mode.
Thanks.
--
dujinhang
rib.serde2.RegexSerDe'
> With SERDEPROPERTIES (
> "input.regex"="(\\d+)&&&&(\\d+)&&&&(\\d+)"
> )
> LOCATION '/path1;
>
>
> 2011/5/25 jinhang du
>
>> Hi all，
>>
>> I want to custom the del
Hi all，
I want to custom the delimiter of the table in a row.
Like my data format is '124‘, and how could I create a table (int,
int, int)
Thanks.
--
dujinhang
Set the follow property in hive.site.xml.
fs.default.name = hdfs:
mapred.job.tracker =
hive.metastore.warehouse.dir =
Make sure you have the authority to write into this directory
(hive.metastore.warehouse.dir).
Try it.
2011/5/23 MIS
> I'm getting into an issue when trying to run hive over t
thx.
2011/5/18 jinhang du
> Thanks for your answers.
>
> I run my hive client console on a machine which doesn't belong to the
> hadoop cluster.
> I just changed "fs.default.name" and "mapred.job.tracker" in hive-site.xml
> to connect the hadoop cluster.
>
about my operations or my understanding about
hive?
Can hive just act a client without any changes on hadoop configuration?
Thanks.
2011/5/18 Ted Yu
> Can you try as user hadoop ?
>
> Cheers
>
>
>
> On May 17, 2011, at 9:53 PM, jinhang du wrote:
>
> > hi,
>
hi,
The default value is "/user/hive/warehouse" in hive.site.xml. After I
changed the directory to a path on HDFS, I got the exception.
FAILED: Error in metadata: MetaException(message:Got exception:
org.apache.hadoop.security.
AccessControlException org.apache.hadoop.security.AccessControlExcepti
19 matches
Mail list logo
