I want to unsubscribe too.
On 24 August 2015 at 15:38, Nurdan Ahat nurdan.a...@gmail.com wrote:
No table is not transactional
On Aug 24, 2015 10:30 AM, Elliot West tea...@gmail.com wrote:
Is the table configured to be transactional?
https://cwiki.apache.org/confluence/display/Hive/Hive+Transactions#HiveTransactions-TableProperties
On Monday, 24 August 2015, Suyog Parlikar
Can anyone put some light on this please?
On Mon, Aug 24, 2015 at 12:32 PM, Jeetendra G jeetendr...@housing.com
wrote:
HI All,
I have a directory where I have json formatted and parquet files in same
folder. can hive load these?
I am getting Json data and storing in HDFS. later I am
UnSubscribe
On Sun, Aug 23, 2015 at 10:36 AM, Daniel Rijo dan...@ppc.land wrote:
I sent an email to unsubscribe but nothing happened.
--
Mohit Garg
9717040694
Are you using a lock manager, and if so which one? I believe the
ZooKeeper lock manager does not allow simultaneous writes. The lock
manager that comes with the DbTxnManager does, but you can't use that
without also using transactions.
Alan.
Suyog Parlikar mailto:suyogparli...@gmail.com
To unsbuscribe send email to user-unsubscr...@hive.apache.org
Alan.
Nurdan Ahat mailto:nurdan.a...@gmail.com
August 24, 2015 at 6:38
Hi,
You can set a different file format per partition.
You can't mix files in the same directory (You could theoretically write
some kind of custom SerDe).
Daniel.
On Mon, Aug 24, 2015 at 6:15 PM, Jeetendra G jeetendr...@housing.com
wrote:
Can anyone put some light on this please?
On Mon,
If that is the case it sounds like a bug…
From: Jary Du jary...@gmail.commailto:jary...@gmail.com
Reply-To: user@hive.apache.orgmailto:user@hive.apache.org
user@hive.apache.orgmailto:user@hive.apache.org
Date: Thursday, August 20, 2015 at 08:56
To: user@hive.apache.orgmailto:user@hive.apache.org
Hi guys
I am using Hive version = 0.13.1-cdh5.3.3
HIVE TABLE =
qnap_resume_file_location---DROP TABLE IF
EXISTS
qnap_resume_file_location;CREATE EXTERNAL TABLE qnap_resume_file_location
( floc STRING ) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t'
HI All,
I have a directory where I have json formatted and parquet files in same
folder. can hive load these?
I am getting Json data and storing in HDFS. later I am running job to
convert JSon to Parquet(every 15 mins). so we will habe 15 mins Json data.
Can i provide multiple serde in hive?
Hi Sanjay,
Try replacing the 4 backslashes with just 2. Usually works with 2
backslashes.
Replace this *split(reverse(split(reverse(**floc**),'/')[0]),'.')[0]*
as resid
with *split(reverse(split(reverse(floc**),'/')[0]),'\\.')[0]* as
resid
Please have a look and let us know if that
Hi Vivek
Thanks A few more experiments
The \\ , \\\ and all work correctly if used as following
split(reverse(split(reverse(floc),'/')[0]),'[\\.]')[0] (need those square
brackets)
split(reverse(split(reverse(floc),'/')[0]),'\\\.')[0] (does not need square
brackets)
Hi All
I am a beginner in hive
And I am using '^O' with rlike, but it doesn't seem to be workingI am using
hive 1.2.0.
Please help
thanksrakesh
Hello,
I am interested to get the cost of the query plans as calculated by the
CBO. How can I get that information ? For example, consider a query with a
three way join of the following form:
Query
=
insert overwrite table output_tab
select
a_day, a_product, b_alternate, (a_sales + b_sales
Raajay,
You don't have col stats hence it assumes 1 for row count.
What version of Hive are you on?
Thanks
John
From: Raajay raaja...@gmail.commailto:raaja...@gmail.com
Reply-To: user@hive.apache.orgmailto:user@hive.apache.org
user@hive.apache.orgmailto:user@hive.apache.org
Date: Monday,
Hi John,
I am on Hive-2.0.0. I forked of the Hive master branch 2 weeks back
(commit id: 763cb02b5eafb0ecd3fd0eb512636a1b092df671).
I actually have analyze before I execute the query. I left it out for
brevity. Please find the entire query (sent to hive in a file) below.
Without the analyze
Hi,
I'd like to have write access to the Hive wiki. My Confluence username is
jia.a...@intel.commailto:jia.a...@intel.com with Full Name Jia Ke. Please
help me deal with it. Thank you!
Regards,
Jia Ke
Hi Guys,
I managed to delete some data in HDFS by dropping a partitioned external
Hive table. One explanation is that data resided in the 'warehouse'
directory of Hive and that had something to do with?
An alternative explanation may that my 'drop table' statement didn't delete
the data but my
In addition to col stats you also need table stats.
From: John Pullokkaran
jpullokka...@hortonworks.commailto:jpullokka...@hortonworks.com
Reply-To: user@hive.apache.orgmailto:user@hive.apache.org
user@hive.apache.orgmailto:user@hive.apache.org
Date: Monday, August 24, 2015 at 5:23 PM
To:
Hi,
I'd like to have write access to the Hive wiki. My Confluence username is
ke.a@intel.commailto:ke.a@intel.com with Full Name Jia Ke. Please
help me deal with it. Thank you!
Regards,
Jia Ke
From the text below it seems like you are not collecting table level stats.
You can collect table level stats by following
analyze table table name compute statistics;
Thanks
John
On 8/24/15, 6:24 PM, Raajay raaja...@gmail.com wrote:
Hi John,
I am on Hive-2.0.0. I forked of the Hive master
Ah okay. Thanks a lot! Now I can get non-default values after collecting
table level stats.
CalciteOptimizedPlan looks like this:
HiveProject(a_day=[$4], a_product=[$5], b_alternate=[$2],
total_sales=[+(+($6, $3), $9)]): rowcount = 6.112516920555744E9, cumulative
cost = {3.8838122487221785E7
Done. Welcome to Hive!
On Mon, Aug 24, 2015 at 7:09 PM, Jia, Ke A ke.a@intel.com wrote:
Hi,
I’d like to have write access to the Hive wiki. My Confluence username is
ke.a@intel.com with Full Name “Jia Ke”. Please help me deal with it.
Thank you!
Regards,
Jia Ke
23 matches
Mail list logo