Hi,
I have a hive table query:
create external table test (field1 struct< `inner-table` : string>);
I believe hyphens are disallowed but to overcome that i read that we can
use ``(ticks) around them. But even this seems to fail.
Is there a way around this or hypens are not allowed in nested hi
when I compile Hive 1.1 from src on my server, it encounter errors like below :
[ERROR] Failed to execute goal on project hive-shims-0.23: Could not resolve
dependencies for project org.apache.hive.shims:hive-shims-0.23:jar:1.1.0: The
following artifacts could not be resolved:
org.xerial.snapp
Hi,
I have a Hive table stored as ORC with the following properties:
# Detailed Table Information
Database: default
Owner: root
CreateTime: Tue Mar 24 21:33:53 PDT 2015
LastAccessTime: UNKNOWN
Protect Mode: None
Retention:
Thanks a lot. That worked for me.
On Wed, Mar 25, 2015 at 2:40 AM, Steve Howard
wrote:
> What happens if you try it with the actual colon rather than the encoded
> value?
>
> alter table my_tbl drop partition (date='2014-01-02 00:00:00.0') ;
>
> On Tue, Mar 24, 2015 at 12:37 AM, Megha Garg
> w
Hi
Is there any way in hive0.10 to rename a database ?
Thanks
Hi,
Any mechanism which bypasses schema layers for SQL is a bad idea.
See this example for how you can connect to HiveServer2 directly from Java
-
https://cwiki.apache.org/confluence/display/Hive/HiveServer2+Clients#HiveSe
rver2Clients-JDBCClientSampleCode
Use the JDBC driver to access HiveServ
?
Thanks everyone, too! Congrats to Jimmy and Sergio.
I hear we will soon receive some "karma".
From: Jimmy Xiang
Sent: Tuesday, March 24, 2015 8:41 AM
To: user@hive.apache.org
Cc: sanjiv.is...@gmail.com; d...@hive.apache.org; Matthew McCline;
jxi...@apache.o
Hm I ran it analyze stats again and it worked second timeL
MapReduce Total cumulative CPU time: 5 minutes 26 seconds 500 msec
Ended Job = job_1426887201015_0016
Table oraclehadoop.tdash stats: [numFiles=4, numRows=400,
totalSize=32568651117, rawDataSize=32564651117]
MapReduce Jobs Launch
What happens if you try it with the actual colon rather than the encoded
value?
alter table my_tbl drop partition (date='2014-01-02 00:00:00.0') ;
On Tue, Mar 24, 2015 at 12:37 AM, Megha Garg wrote:
> Thanks for correcting, that was a typo. My actual command is :-
>
> alter table my_tbl drop
Hi all,
Trying to analyze stats on 4 million rows table imported from Oracle via
Sqoop and Hive
0: jdbc:hive2://rhes564:10010/default> analyze table tdash compute
statistics;
INFO : Hadoop job information for Stage-0: number of mappers: 121; number
of reducers: 0
INFO : 2015-03-24
Hey all,
I have cloudera 5.3, and an issue involving HiveServer2, Hive.
We have a process that launches Hive JDBC queries, hourly. This process
selects from one table and builds another.
It looks something like this (slightly obfuscated query)
FROM beacon INSERT OVERWRITE TABLE author_arti
Thanks everyone! Congrats to Sergio and Matt!!
On Mon, Mar 23, 2015 at 11:36 PM, Xu, Cheng A wrote:
> Congratulations!!!
>
>
>
> *From:* @Sanjiv Singh [mailto:sanjiv.is...@gmail.com]
> *Sent:* Tuesday, March 24, 2015 12:45 PM
> *To:* user@hive.apache.org
> *Cc:* d...@hive.apache.org; mmccl...@h
UDF's are great but if you do not want to use one, you can still convert
Long dates into short dates using the set of inbuilt functions.
Thu Mar 19 08:30:06 + 2015 (stored as string) can be converted
into 2015-03-19 14:00:06 (stored as date timestamp object - all times
referred from local time
13 matches
Mail list logo
