Those configurations are all deprecated and you can remove warning message
by setting hive.conf.validation=false.
Don't know why Ambari needs that configurations.
Thanks,
Navis
2015-01-28 12:40 GMT+09:00 Devopam Mittra devo...@gmail.com:
+1
I also need help on this one in particular
Yes, it's a bug. Seemed not handling properly with PRECEDING+PRECEDING
or FOLLOWING+FOLLOWING cases.
Thanks,
Navis
2015-01-18 4:40 GMT+09:00 DU DU will...@gmail.com:
Hi folks,
The window clause in Hive 0.13.* does not work for the following example
statement
- BETWEEN 2 PRECEDING AND 1
There seemed not registered issue in hive. Really appreciate if you do that.
Thanks,
Navis
2015-01-19 10:56 GMT+09:00 Dayong will...@gmail.com:
Is it reported? If not, I'll report it?
Thanks,
Dayong
On Jan 18, 2015, at 8:41 PM, Navis류승우 navis@nexr.com wrote:
Yes, it's a bug. Seemed
When using hive shell, it's shown in console something like,
hive (default) select * from src order by key limit 10;
Query ID = navis_20141230100808_09c0a077-442e-4943-a136-710cba6e94d1
Total jobs = 1
Launching Job 1 out of 1
Status: Running (Executing on YARN cluster with App id
Try with set
hive.input.format=org.apache.hadoop.hive.ql.io.HiveInputFormat
Thanks,
Navis
2014-12-24 18:27 GMT+09:00 村下瑛 akira.murash...@gmail.com:
Hi, all
I am trying to load pig output from Hive as an external table,
and currently stuck with that Hive always set the number of mappers to
Afaik, it was restricted by implementation of hadoop. But now hadoop-2
supports custom delimiter, hopefully it also can be implemented in hive.
I'm not sure but currently possible way of do that is setting
textinputformat.record.delimiter in table properties.
Thanks,
Navis
2014-12-18 6:20
The states in UDF(which is represented as states SomeClass3) are needed?
If it's not, you can try them mark as a transient field.
Thanks,
Navis
2014-10-20 23:59 GMT+09:00 Harel Gliksman harelg...@gmail.com:
Hello,
I am experiencing inconsistent behavior when trying to use UDF on 0.13.1
on
Could you tell the version number of hive?
Thanks,
Navis
2014-10-15 2:00 GMT+09:00 Time Less timelessn...@gmail.com:
I have found a work-around for this bug. After you issue the ALTER
TABLE...CONCATENATE command, issue:
ALTER TABLE T1 PARTITION (P1) SET LOCATION
Try with set hive.default.fileformat=SequenceFile;
Thanks,
Navis
2014-10-06 20:51 GMT+09:00 Maciek mac...@sonra.io:
Hello,
I've encountered a situation when printing new lines corrupts (multiplies)
the returned dataset.
This seem to be similar to HIVE-3012
Stateful function should be called for all input rows but in if/when
clause, it cannot be guaranteed.
Any reason to declare protect_column function to be stateful?
Thanks,
Navis
2014-09-25 3:42 GMT+09:00 Dan Fan d...@appnexus.com:
Hi Hive Users:
I have a hive generic hive udf which is
Could you try cast(calldate as string)?
Thanks,
Navis
2014-08-12 20:22 GMT+09:00 ilhami Kalkan ilhami.kal...@intellica.net:
Hi all,
I have a problem with IN statement in HiveQL. My table cdr, column
calldate which type is date. First query is successfully return:
select * from cdr where
Could you do it with hive.ignore.mapjoin.hint=false? Mapjoin hint is
ignored from hive-0.11.0 by default (see
https://issues.apache.org/jira/browse/HIVE-4042)
Thanks,
Navis
2014-07-31 10:04 GMT+09:00 Chen Song chen.song...@gmail.com:
I am using cdh5 with hive 0.12. We have some hive jobs
Set value of hive.querylog.location to empty string in hive-site.xml.
Thanks,
Navis
2014-07-31 13:08 GMT+09:00 Gitansh Chadha gita...@gmail.com:
Hi,
I want to stop hive commands from generating the hive job file (under
/tmp/user/hive_log_job*) for every query, as we run multiple queries in
Looks like it's caused by HIVE-7314. Could you try that with
hive.cache.expr.evaluation=false?
Thanks,
Navis
2014-07-24 14:34 GMT+09:00 丁桂涛(桂花) dinggui...@baixing.com:
Yes. The output is correct: [tp,p,sp].
I developed the UDF using JAVA in eclipse and exported the jar file into
the auxlib
https://issues.apache.org/jira/browse/HIVE-5799 is for that kind of cases,
but not included in releases yet.
Thanks,
Navis
2014-07-24 20:04 GMT+09:00 Zhanghe (D) crane.zh...@huawei.com:
Hey Guys,
I'm working with HiveServer2. I know the HiveServer holds a session for
each client, and
to look at.
Thanks,
Sai
On Sun, Jul 20, 2014 at 9:23 PM, Navis류승우 navis@nexr.com wrote:
You can implement that in Hook and register in hive-site.xml.
Thanks,
Navis
2014-07-19 17:32 GMT+09:00 sai chaitanya tirumerla tirume...@gmail.com:
Hi,
I would like to restrict users doing
I thinks it's fixed in https://issues.apache.org/jira/browse/HIVE-7011,
which will be included in hive-0.14.0. Sadly, there seemed no simple
walkaround for this.
Thanks,
Navis
2014-07-19 15:03 GMT+09:00 Yang tedd...@gmail.com:
we are getting a random (happening about 20% of the time, if
HIVE-4095, originally intended to implement,
alter table target_table_name exchange partition (partition spec) with
table source_table_name;
But in implementation, Dheeraj Kumar Singh, the original implementor, seemed
confused and implemented this in inverted manner (target to source).
You can implement that in Hook and register in hive-site.xml.
Thanks,
Navis
2014-07-19 17:32 GMT+09:00 sai chaitanya tirumerla tirume...@gmail.com:
Hi,
I would like to restrict users doing
select * from table; when accessed from any jdbc/odbc tools like sql
workbench/excel etc..
My bad. Could you do that?
Thanks,
Navis
2014-07-17 9:15 GMT+09:00 Andrew Mains andrew.ma...@kontagent.com:
Hi all,
I'm currently experimenting with using the new HBaseKeyFactory interface
(implemented in https://issues.apache.org/jira/browse/HIVE-6411) to do
some custom serialization
For cache.expr.evaluation problem, it's fixed in
https://issues.apache.org/jira/browse/HIVE-7314 (will be included in next
release)
But I agree that it can be a critical problem for users of 0.12.0 and
0.13.x version and need proper warning on that.
Thanks,
Navis
2014-07-13 16:48 GMT+09:00 郭士伟
It's cross producting. Not strange taking so much time even with small
tables.
Thanks,
Navis
2014-07-09 2:53 GMT+09:00 Malligarjunan S malligarju...@gmail.com:
Hello All,
Can any one help me to answer to my question posted on Stackoverflow?
java.lang.Long
50:34 7176 [Z
On 8 July 2014 at 08:40:20, Navis류승우 (navis@nexr.com
//navis@nexr.com) wrote:
Could you try jmap -histo:live pid and check hive objects which seemed
too many?
Thanks,
Navis
2014-07-07 22:22 GMT+09:00 jonas.partner jonas.part
Yes, 2M x 1M makes 2T pairing in single reducer.
Thanks,
Navis
2014-07-10 1:50 GMT+09:00 Malligarjunan S malligarju...@gmail.com:
Hello All,
Is that the expected behavior from hive to take so much of time?
Thanks and Regards,
Sankar S
On Tue, Jul 8, 2014 at 11:23 PM, Malligarjunan S
In GenTezProcContext, you can find new
TezWork(conf.getVar(HiveConf.ConfVars.HIVEQUERYID)) part. And the final
name is name + : + (++counter);
Thanks,
Navis
2014-07-10 12:43 GMT+09:00 Grandl Robert rgra...@yahoo.com:
Hi guys,
I am trying to identify a DAG in Tez with a different id, based
Looks like HIVE-6913(https://issues.apache.org/jira/browse/HIVE-6913) and
will be fixed in hive-0.14.0.
Thanks,
Navis
2014-07-04 17:12 GMT+09:00 sunww spe...@outlook.com:
Hi
I'm using hive0.11 and hadoop2.2. When I use a large table join on
two empty tables , it convert to mapjoin
Could you try jmap -histo:live pid and check hive objects which seemed
too many?
Thanks,
Navis
2014-07-07 22:22 GMT+09:00 jonas.partner jonas.part...@opencredo.com:
Hi Benjamin,
Unfortunately this was a really critical issue for us and I didn’t think
we would find a fix in time so we
Seemed regression of HIVE-6386. Will be fixed in next version.
2014-06-26 7:58 GMT+09:00 Sumit Kumar skbrnwl-...@yahoo.com:
Hey guys,
I just discovered that this syntax doesn't print the dbproperties any
more. I've two hive versions that i'm testing following query on:
create database
Booked in https://issues.apache.org/jira/browse/HIVE-7298
Thanks,
2014-06-26 14:28 GMT+09:00 Navis류승우 navis@nexr.com:
Seemed regression of HIVE-6386. Will be fixed in next version.
2014-06-26 7:58 GMT+09:00 Sumit Kumar skbrnwl-...@yahoo.com:
Hey guys,
I just discovered
It's fixed in HIVE-6432. I think you should rebuild your own hcatalog from
source with profile -Phadoop-1.
2014-06-05 9:08 GMT+09:00 Sundaramoorthy, Malliyanathan
malliyanathan.sundaramoor...@citi.com:
Hi,
I am using Hadoop 2.4.0 with Hive 0.13 + included package of HCatalog .
Wrote a
It's seconds.
new Date(time * 1000);
2014-05-22 14:19 GMT+09:00 Santhosh Thomas santhosh.tho...@yahoo.com:
I am trying to find the creation time of a table using table.createTime()
function. I was hoping that it returns the time in milli seconds, but looks
like it is not. Any idea how to
It's a bug in ColumnAccessAnalyzer. I've booked this on
https://issues.apache.org/jira/browse/HIVE-6910.
Thanks,
Navis
2014-04-15 11:41 GMT+09:00 Adeel Qureshi adeelmahm...@gmail.com:
I am trying to read the columns from hive queries being executed by
implementing the ExecuteWithHookContext
try
hive.hadoop.supports.splittable.combineinputformat=true;
Thanks,
Navis
2014-04-01 15:55 GMT+09:00 Sreenath sreenaths1...@gmail.com:
Hi all,
I have a partitioned table in hive where each partition will have 630 gzip
compressed files each of average size 100kb. If I query over these files
You can check the exact reason from job log, but generally, it's
caused by missing libs in auxlib conf.
Thar includes hive-hbase-handler.jar, hbase-*.jar, guava-*.jar,
zookeeper-*.jar, etc. ,varying the version of your hive and hbase.
Thanks,
Navis
2014-03-20 3:42 GMT+09:00 Sunil Ranka
-2584
--
chenchun
On Friday, 14 March, 2014 at 11:50 AM, Navis류승우 wrote:
HIVE-4064 is expected to solve this kind of problems in hive but not
in progress even it's not that hard to implement.
I'll take a look at it when I'm free.
Thanks,
Navis
2014-03-13 22:08 GMT+09:00 Clay McDonald
HIVE-4064 is expected to solve this kind of problems in hive but not
in progress even it's not that hard to implement.
I'll take a look at it when I'm free.
Thanks,
Navis
2014-03-13 22:08 GMT+09:00 Clay McDonald stuart.mcdon...@bateswhite.com:
Hello everyone, I'm running Hive 0.12.0 and I
User provided classes (by adding jars) should be unloaded when the
session is closed. https://issues.apache.org/jira/browse/HIVE-3969 is
about that but it's not resolved yet.
Thanks,
Navis
2014-03-12 8:56 GMT+09:00 Ashu Pachauri a...@rocketfuelinc.com:
We use Hive-0.12 and are planning to use
The 100 100 is the sole matching row for the join condition, so it
would be right result,
NULLNULLNULL40
NULLNULL12 35
NULLNULL48 NULL
NULL40 NULLNULL
12 35 NULLNULL
48 NULLNULLNULL
100 100 100 100
It's
Then you should use BETWEEN, not IN. BETWEEN can be used for PPD, afaik.
2014-03-11 16:33 GMT+09:00 Petter von Dolwitz (Hem)
petter.von.dolw...@gmail.com:
Hi Young,
I must argue that the partition pruning do actually work if I don't use the
IN clause. What I wanted to achieve in my original
(KW_IN expressions)
- ^(TOK_FUNCTION KW_IN $precedenceEqualExpression expressions)
expressions
:
LPAREN expression (COMMA expression)* RPAREN - expression*
;
You should have arguments of IN wrapped by parentheses. But It seemed
not possible to use array returning expression in
Declare it as a binary column and use decoding UDF when accessing it.
Thanks,
Navis
2014-02-20 12:21 GMT+09:00 kun yan yankunhad...@gmail.com:
Hi all
GBK encoding data files, but the hive is UTF-8 encoding
select * from table display normal
I try to modify the following configuration
partitioning on file level rather than on
directory level?
Thanks,
Petter
2014-03-04 7:32 GMT+01:00 Navis류승우 navis@nexr.com:
You might be interested in https://issues.apache.org/jira/browse/HIVE-1662,
using predicate on file-name vc to filter out inputs. For example,
select key
You might be interested in https://issues.apache.org/jira/browse/HIVE-1662,
using predicate on file-name vc to filter out inputs. For example,
select key,INPUT__FILE__NAME from srcbucket2 where INPUT__FILE__NAME rlike
'.*/srcbucket2[03].txt'
But it's not committed, yet.
Thanks,
2014-03-03
https://issues.apache.org/jira/browse/HIVE-6411 is exactly for the cases.
The bad new is that it seemed not included even in 0.13.0 and you should
implement own predicate analyzer.
Thanks,
Navis
2014-03-03 20:52 GMT+09:00 Juraj jiv fatcap@gmail.com:
Hello,
im currently testing Hbase
Congratulations, Xuefu!
2014-03-01 14:38 GMT+09:00 Lefty Leverenz leftylever...@gmail.com:
Congrats Xuefu!
-- Lefty
On Fri, Feb 28, 2014 at 2:52 PM, Eric Hanson (BIG DATA)
eric.n.han...@microsoft.com wrote:
Congratulations Xuefu!
-Original Message-
From: Remus Rusanu
It's HIVE-5779 and will be fixed in hive-0.13.0.
Thanks,
Navis
2014-02-21 21:07 GMT+09:00 Rafal Janik rafal.ja...@softwaremind.pl:
Hi All,
I've just started my adventure with Hive so I'm not sure if it's an issue
here or just my misunderstanding...
I'm using Hortonworks Sandbox 2.0 (Hive
If key is unique, you might overwrite values by using hbase handler.
2014-02-18 22:05 GMT+09:00 yogesh dhari yogeshh...@gmail.com:
Yes, Hive does not provide update statement, I am just looking for the
work arround it, how to implement it
On Tue, Feb 18, 2014 at 6:27 PM, Peter Marron
With HIVE-3746, which will be included in hive-0.13, HiveServer2 takes less
memory than before.
Could you try it with the version in trunk?
2014-02-13 10:49 GMT+09:00 Stephen Sprague sprag...@gmail.com:
question to the original poster. closure appreciated!
On Fri, Jan 31, 2014 at 12:22
If it should be sampled using subquery would be inevitable, something like,
select x from (select distinct key as x from src)a where rand() 0.9 limit
10;
2014-02-12 6:07 GMT+09:00 Oliver Keyes oke...@wikimedia.org:
Hey all
So, what I'm looking to do is get N randomly-sampled distinct
HBase storage handler uses it's own InputFormat.
So, hbase.client.scanner.caching (which is used in hbase.TableInputFormat)
does not work. It might be configurable via HIVE-2906, something like
select empno, ename from hbase_emp ('hbase.scan.cache'='1000'). But I've
not tried.
bq. Is there any
It's supposed to be implemented after
https://issues.apache.org/jira/browse/HIVE-1662 would be checked in. But
it's not in progress for a year.
Thanks,
2014-02-06 John Meza j_meza...@hotmail.com:
A couple of simple questions on logfile organization in HDFS and
referenced by an external
if
hive.stats.autogather was 'false' when the data was loaded? (See the
wiki's Statistics in Hive doc: Existing
Tableshttps://cwiki.apache.org/confluence/display/Hive/StatsDev#StatsDev-ExistingTables
.)
-- Lefty
On Sun, Jan 26, 2014 at 8:01 PM, Navis류승우 navis@nexr.com wrote:
If the data
1. current implementation of hbase handler cannot pushdown filter with
'like' expression. You might rewrite the query some thing like key =
0010_0 AND key = 0010_9
2. Each of all tasks seemed to be scanning whole table (ie. 1000+ time),
which is fixed in
try set hive.mapred.local.mem=7000 or add it to hive-site.xml instead of
modifying hive-env.sh
HADOOP_HEAPSIZE is not in use. Should fix documentation of it.
Thanks,
Navis
2014-01-31 Avrilia Floratou avrilia.flora...@gmail.com:
Hi,
I'm running hive 0.12 on yarn and I'm trying to convert a
If the data is loaded into table with insert clause with
hive.stats.autogather=true, it will be updated. If it's not, it's zero (or
-1 sometimes).
2014-01-23 Haroon Muhammad muhammad.har...@live.com
Hi,
I have observed that DESCRIBE EXTENDED always shows number of rows to be
zero despite
HIVE-3746 modified IDL to handle nulls in more performant manner.
(hiveserver1 does not handle nulls)
Thanks.
2013/11/6 B C ahatest2...@yahoo.com
hi,
We are building ms sql cube by linkedserver connecting to hiveserver with
Cloudera's ODBC driver.
There are two test results:
1.
Navis류승우 navis@nexr.com
Hive uses path to table(or partition) mapping internally (you can see
that in MapredWork, etc.), which might caused first table overwritten by
other.
I didn't tried symlink on hdfs, which could be a solution.
2013/12/12 Petter von Dolwitz (Hem) petter.von.dolw
Could you post hive version and execution plan for the query?
2013/12/21 Martin, Nick nimar...@pssd.com
Hi all,
I have two tables:
tbl1: 81m rows
tbl2: 4m rows
tbl1 is partitioned on one column and tbl2 has none.
I’m attempting the following query:
SELECT
tbl1.col_pk,
IndexPredicateAnalyzer in hive supports AND conjunction only because it's
simple. Anyone can implement one that supports conjunctions like OR, CASE,
etc. if needed. If you might provide that to hive community, it would be
really appreciated.
ps.
There is a draft patch handling OR conjuncted
Hive uses path to table(or partition) mapping internally (you can see that
in MapredWork, etc.), which might caused first table overwritten by other.
I didn't tried symlink on hdfs, which could be a solution.
2013/12/12 Petter von Dolwitz (Hem) petter.von.dolw...@gmail.com
Hi,
I have
Is there someone who knows how to do this?
2013/11/30 Xiao Meng xi...@simba.com
Hi,
I would like update/fix some contents on the performance test part. My
user name is xiaom.
Thanks,
Xiao
Looks like a bug. I've booked this on
https://issues.apache.org/jira/browse/HIVE-5935.
2013/12/4 Adam Kawa kawa.a...@gmail.com
Maybe you can parse the output of EXPLAIN operator applied on your query
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Explain
or look for other
I've booked on https://issues.apache.org/jira/browse/HIVE-5858 for the
ALTER TABLE issue, mentioned by David Morel (Thanks).
2013/11/20 David Morel dmore...@gmail.com
On 18 Nov 2013, at 21:59, Stephen Sprague wrote:
A word of warning for users of HiveServer2 - version 0.11 at least. This
in handling PARTIAL1,
inputOI = (StandardListObjectInspector) parameters[0];
return ObjectInspectorFactory.getStandardListObjectInspector(inputOI);
1.
inputOI is not guaranteed to be a StandardListObjectInspector.
Use ListObjectInspector instead.
2.
From perspective of RS, two query is just different in hash code of RS key.
The cost of calculating hash of col3 and col4 might be negligible, I think.
2013/11/1 KayVajj vajjalak...@gmail.com
Any response or pointers to understand how Cluster By in sub queries can
affect the performance/speed
Congrats!
2013/10/25 Gunther Hagleitner ghagleit...@hortonworks.com
Congrats Thejas and Brock!
Thanks,
Gunther.
On Thu, Oct 24, 2013 at 3:25 PM, Prasad Mujumdar pras...@cloudera.com
wrote:
Congratulations Thejas and Brock !
thanks
Prasad
On Thu, Oct 24, 2013 at
how might map to similar hashcode
values?
Also is changing the alias the only workaround for this problem or is
there any other workaround possible?
Thanks,
Amit
On Sun, Aug 11, 2013 at 9:22 PM, Navis류승우 navis@nexr.com wrote:
Hi,
Hive is notorious making different result
It looks like counting codes from company of committer, not of the author.
Considering the huge amount of works by Ashutosh, it's not strange.
2013/9/13 Sanjay Subramanian sanjay.subraman...@wizecommerce.com
I have not read the full blogs but in the year 2013 , IMHO , LOC is a
very old
Congratulations!
2013/8/20 Clark Yang (杨卓荦) yangzhuo...@gmail.com:
Congrats Thejas!
在 2013年8月20日星期二,Carl Steinbach 写道:
The Apache Hive PMC has voted to make Thejas Nair a committer on the Apache
Hive project.
Please join me in congratulating Thejas!
Looks like a bug. I'll fix that.
2013/8/15 Jan Dolinár dolik@gmail.com:
Hi everyone,
Consider following DDL:
CREATE TABLE partition_test
(a INT)
PARTITIONED BY (b INT);
ALTER TABLE partition_test ADD
PARTITION (b=1) location '/tmp/test1'
PARTITION
https://issues.apache.org/jira/browse/HIVE-5122
2013/8/20 Navis류승우 navis@nexr.com:
Looks like a bug. I'll fix that.
2013/8/15 Jan Dolinár dolik@gmail.com:
Hi everyone,
Consider following DDL:
CREATE TABLE partition_test
(a INT)
PARTITIONED BY (b INT);
ALTER
Hi,
I've booked this on https://issues.apache.org/jira/browse/HIVE-5056
and attached patch for it.
It needs full test for confirmation but you can try it.
Thanks.
2013/8/11 wzc1...@gmail.com:
Hi all:
when I change the table alias dim_pay_date to A, the query pass in hive
of 'deal' and 'dim_pay_date' are
the same and the code in MapJoinProcessor.java ignores the order of
rowschema.
I look at your patch and it's exactly the same place we are working on.
Thanks for your patch.
在 2013年8月11日星期日,下午9:38,Navis류승우 写道:
Hi,
I've booked this on https://issues.apache.org
Could you upload DDLs for those tables? Thanks.
2013/8/8 Jérôme Verdier verdier.jerom...@gmail.com:
Hi,
I encountered a problem with Right Outer Join in Hive.
Here is where is the problem :
FROM default.ca ca
JOIN default.kpi_magasin mtransf
ON
I've booked this on https://issues.apache.org/jira/browse/HIVE-5025.
2013/7/22 Felix.徐 ygnhz...@gmail.com:
Hi all,
Is there any api to retrieve the parameter's column name in GenericUDF?
For example:
Select UDFTEST(columnA,columnB) from test;
I want to get the column names(columnA and
I've booked this and attached patch for it.
https://issues.apache.org/jira/browse/HIVE-4932
Could you test with that? thanks.
2013/7/25 Lars Francke lars.fran...@gmail.com:
We're still being bitten by this problem without a workaround. Does
anyone have an idea?
Thanks,
Lars
On Wed, Jul
It will be called 4 times whatever you annotated on the UDF if you are
using released version of hive.
https://issues.apache.org/jira/browse/HIVE-4209 , which will be
included in 0.12.0, will make that single UDF call by caching result.
2013/7/24 Sanjay Subramanian
I'm a little late. Congratulations Gunther and Brock!
2013/7/21 Prasanth J j.prasant...@gmail.com:
Congrats Gunther!
Thanks
-- Prasanth
On Jul 21, 2013, at 1:00 AM, Carl Steinbach c...@apache.org wrote:
The Apache Hive PMC has voted to make Gunther Hagleitner a
committer on the Apache
for this ?
2013/7/10 Navis류승우 navis@nexr.com
Attached patch for this in https://issues.apache.org/jira/browse/HIVE-4837
2013/7/10 Navis류승우 navis@nexr.com:
Could you try to remove NULL as FLG_DEM_INC_PRX_CS_VALs in the query?
It seemed not related to HIVE-4650 but still a bug (I'll
Fixed in hive-0.11.0
https://issues.apache.org/jira/browse/HIVE-3682
2013/7/11 Sanjay Subramanian sanjay.subraman...@wizecommerce.com:
Hive does not have a output delimiter specifier yet (not sure if 0.11.x may
have it)
But for now please try the following
hive -e myquery | sed 's/\t/,/g'
Could you try to remove NULL as FLG_DEM_INC_PRX_CS_VALs in the query?
It seemed not related to HIVE-4650 but still a bug (I'll book this)
2013/7/9 Jérôme Verdier verdier.jerom...@gmail.com:
Hi,
Thanks for your help.
You can see logs below :
java.lang.RuntimeException: Error in configuring
It seemed stmt.setFetchSize(1); can be called before execution
(without casting)
2013/7/3 Christian Schneider cschneiderpub...@gmail.com:
Hi, i browsed through the sources and found a way to tune the JDBC
ResultSet.next() performance.
final Connection con =
MetadataOnlyOptimizer changes GBY on partition columns to simple
TableScan with one line dummy.
I think similar things can be done with stats.
2013/6/28 Peter Marron peter.mar...@trilliumsoftware.com:
Hi,
I feel sure that someone has asked for this before, but here goes…
In the case
have found.
Are there any descriptions, motivations, documentation or examples anywhere?
I suspect that there's nothing other than the source itself, but I had to ask.
Regards,
Z
-Original Message-
From: Navis류승우 [mailto:navis@nexr.com]
Sent: 02 July 2013 08:50
To: user
Currently it's not. https://issues.apache.org/jira/browse/HIVE-3946
2013/7/3 Felix.徐 ygnhz...@gmail.com:
Hi all,
Is it possible to specify reducer number for each stage ? how?
thanks!
5月14日星期二,下午2:17,Navis류승우 写道:
In short, hive tags rows a filter mask as a short for outer join,
which can contain 16 flags. (see HIVE-3411, plz)
I'll survey for a solution.
2013/5/14 wzc1989 wzc1...@gmail.com:
hive cannot merge joins of 16+ aliases with outer join into single stage.
In our
We uses https://issues.apache.org/jira/browse/HIVE-3235 and kill jobs if
needed.
2013/6/26 Stephen Sprague sprag...@gmail.com
all it is is a comment on the line above the first statement - and that'll
show up in the jobtracker. Just as he shows in his example.
On Tue, Jun 25, 2013 at 11:05
If VCs are not on query, it'll not be made in ExecMapper from start.
If you can do something with Reporter instance in MR,
https://issues.apache.org/jira/browse/HIVE-3628 would be helpful.
2013/5/30 Peter Marron peter.mar...@trilliumsoftware.com:
Hi,
Using Hive 0.10.0 over Hadoop 1.0.4.
cannot
merge join 16+ aliases into single stage while hive 0.9 doesn't have such
issue. could you explain this or give me some hint?
Thanks!
--
wzc1989
已使用 Sparrow
在 2013年5月14日星期二,下午12:26,Navis류승우 写道:
The error message means hive cannot merge joins of 16+ aliases with
outer join into single
default.test_join z on a.key = z.key
--
wzc1989
已使用 Sparrow
在 2013年3月29日星期五,上午9:34,Navis류승우 写道:
The problem is mixture of issues (HIVE-3411, HIVE-4209, HIVE-4212,
HIVE-3464) and still not completely fixed even in trunk.
Will be fixed shortly.
2013/3/29 wzc wzc1...@gmail.com:
The bug remains
Currently, hive storage handler reads rows one by one.
https://issues.apache.org/jira/browse/HIVE-3603 is for setting cache
size, which is not yet fixed.
2013/5/1 kulkarni.swar...@gmail.com kulkarni.swar...@gmail.com:
That depends on how dynamic your data is. If it is pretty static, you can
https://issues.apache.org/jira/browse/HIVE-2906 seemed what you are looking
for.
2013/4/30 Richard Payne rjp...@gmail.com
Hi
Is it possible to create a Hive external table pointing to an HBase column
family and for all versions of the data for the keys to be returned rather
than just I
try to change codes in evaluate method like,
for (int i = 0; i numElements; i++) {
Object element = listOI.getListElement(arguments[0].get(), i);
Object product = structOI.getStructFieldData(element,
structOI.getStructFieldRef(productCategory));
The problem is mixture of issues (HIVE-3411, HIVE-4209, HIVE-4212,
HIVE-3464) and still not completely fixed even in trunk.
Will be fixed shortly.
2013/3/29 wzc wzc1...@gmail.com:
The bug remains even if I apply the patch in HIVE-4206 :( The explain
result hasn't change.
2013/3/28 Navis류승우
It's a bug (https://issues.apache.org/jira/browse/HIVE-4206).
Thanks for reporting it.
2013/3/24 wzc wzc1...@gmail.com:
Recently we tried to upgrade our hive from 0.9 to 0.10, but found some of
our hive queries almost 7 times slow. One of such query consists multiple
table outer join on the
It's implemented in trunk, named as reflect2.
https://issues.apache.org/jira/browse/HIVE-4025
2013/3/19 David Lee seek...@gmail.com:
It's relatively straight forward to call static functions in JDK using
reflect. For example,
select reflect(java.lang.Math, max, 2, 3) from mytable limit 1;
Hive uses DBCP as a connection pool.
Ref http://www.datanucleus.org/products/accessplatform_2_2/rdbms/dbcp.html
2013/3/19 Siddharth Tiwari siddharth.tiw...@live.com:
Hi team,
What we have observed is, hive creates so many connections to metastore
(mysql). This makes us change the numer of
https://issues.apache.org/jira/browse/HIVE-3235 could be what you are
searching for.
2013/3/1 Nitin Pawar nitinpawar...@gmail.com
you can set this property mapred.job.name and this should set the name
for the job
On Thu, Feb 28, 2013 at 8:26 PM, Tim Bittersohl t...@innoplexia.comwrote:
Could you try to make transaction related methods synchronized?
It's openTransaction/commitTransaction/isActiveTransaction/rollbackTransaction
on ObjectStore.java
2013/2/22 Hemanth Yamijala yhema...@gmail.com:
Hi,
We are running into the same problem as well. Is there any clue what could
be
HIVE-446 - Implement TRUNCATE : is on trunk (v0.11.0)
HIVE-887 - Allow SELECT col without a mapreduce job : It needs set
hive.fetch.task.conversion=more
2013/1/29 Dean Wampler dean.wamp...@thinkbiganalytics.com:
Oh, another one is
https://issues.apache.org/jira/browse/HIVE-446 - Implement
1 - 100 of 114 matches
Mail list logo