hi gurus,
kindly clarify the following please
- Hive currently does not support indexes or indexes are not used in the
query
- The lowest granularity for concurrency is partition. If table is
partitioned, then partition will be lucked in DML operation
- What is the best file format t
Hi,
I tried the following and it worked fine.
create table foo (x int);
insert into foo values (5);
select * from foo;
But when I try the following, I get NULL
create table bar(x timestamp);
insert into bar values (500);
select * from bar;
Regards,
Anand
On Tue, Oct 27, 2015 at 9:15 PM, Alan
Done. Welcome to the Hive wiki team, Dev!
-- Lefty
On Wed, Oct 28, 2015 at 11:38 AM, Devopam Mittra wrote:
> regards
> Dev
>
>
Hello,
Can some please help. When I execute hive query with as case statement I
get this error " Error while compiling statement: FAILED: SemanticException
[Error 10002]: Line 3:21 Invalid column reference 'mbdate'
Here is the query :
select a.mbcmpy, a.mbwhse, a.mbdept, a.mbitem,
(CASE WHEN t
regards
Dev
Captured in HIVE-12285.
Thanks - Elliot.
On 28 October 2015 at 08:54, Elliot West wrote:
> Perhaps, I'd expect one might wish to make multiple API calls when holding
> a lock, but a suitably implemented client may be able to manage this
> seamlessly. Then again a user may also wish to have expl
An interesting one I noted is that even after killing the process locks are
still held for a long time
First kill the job
/home/hduser/hadoop-2.6.0/bin/hadoop job -kill job_1445590859106_0003
INFO impl.YarnClientImpl: Killed application application_1445590859106_0003
Locks are stil
Perhaps, I'd expect one might wish to make multiple API calls when holding
a lock, but a suitably implemented client may be able to manage this
seamlessly. Then again a user may also wish to have explicit control of
locking. No reason it couldn't offer both. I'll create a JIRA to capture
this. As w
