Thanks for all who replied.
After several retries in vain, I felt the issue might be because of version
mismatch. So I took Hadoop 2.7.1, Spark 1.3.1 and Hive 1.2.1. Tried with
these combination and I could successfully test the hive transactions
without any issue.
Regards,
Sarath.
On Fri, Aug
how tables" command, I get the following messages in the
log file -
2015-08-07 18:41:02,511 INFO [main]: hive.metastore
(HiveMetaStoreClient.java:open(297)) - Trying to connect to metastore with
URI thrift://sarath:9083
2015-08-07 18:41:02,511 INFO [main]: hive.metastore
(HiveMetaStoreClien
You can determine whether this was done by
> looking for a table named TXNS in the hive schema on your Oracle db.
>
> Alan.
>
> Sarath Chandra
> August 3, 2015 at 6:29
> Hi All,
>
> Earlier I was using hive 0.13.0 and now trying to migrate to latest
> version to u
sactions.html
>>
>> You need to specify the following properties as well:
>>
>>-
>>
>>hive.txn.driver
>>-
>>
>>hive.compactor.initiator.on
>>-
>>
>>hive.compactor.worker.threads
>>
>>
>>
sactions: Error communicating with
the metastore*
But if disable the "hive.txn.manager" parameter in hive-site.xml then the
command works fine.
Is there anything else to be configured which I'm missing?
Thanks & Regards,
Sarath.
Thanks Nitin. I'm using 0.13.1 version.
I think they documentation needs to be updated to highlight this so that
beginner users like me doesn't need to struggle to figure it out.
On Tue, May 12, 2015 at 5:09 PM, nitinpathakala .
wrote:
> Hi Sarath,
>
> Hive columns are
Hi All,
I've created a external table in hive as -
create table table1(...) partitioned by(CONTEXT_ID string) row format
delimited fields terminated by '\\;' location '/user/sarath/table1/';
Then I created a HDFS folder as '/user/sarath/table1/CONTEXT_ID=A123
bility
> Maybe try to find what version of the slf libraries you have installed (in
> hadoop? hive?), and try updating to later version.
>
>
>
> On Jul 10, 2014, at 9:57 PM, Sarath Chandra <
> sarathchandra.jos...@algofusiontech.com> wrote:
>
> I'm using Hadoop 1
Thanks Peyman. It works perfectly.
On Sat, Jul 12, 2014 at 7:40 PM, Peyman Mohajerian
wrote:
> https://github.com/ogrodnek/csv-serde
>
>
> On Sat, Jul 12, 2014 at 9:17 AM, Sarath P R
> wrote:
>
>> Is there any way to strip double quotes while loading csv file into hi
Is there any way to strip double quotes while loading csv file into hive
table ?
I am using Hive 0.12.
--
Thank You
Sarath P R
Contact +91 99 95 02 4287 | Twitter <http://twitter.com/sarathpr> | Blog
<http://sprism.blogspot.in>
Is there any way to strip double quotes while loading csv file into hive
table ?
I am using Hive 0.12.
--
Thank You
Sarath P R
Contact +91 99 95 02 4287 | Twitter <http://twitter.com/sarathpr> | Blog
<http://sprism.blogspot.in>
I'm using Hadoop 1.0.4. Suspecting some compatibility issues I moved from
Hive 0.13 to Hive 0.12.
But the exceptions related to SL4J still persist.
Unable to move forward with hive to finalize a critical product design. Can
somebody please help me?
On Wed, Jul 9, 2014 at 11:25 AM, S
g
> hive --service metastore
>
>
>
> On Tue, Jul 8, 2014 at 5:27 AM, Sarath Chandra <
> sarathchandra.jos...@algofusiontech.com> wrote:
>
>> Thanks Santhosh.
>> So before going to launch hive shell, we need to start hive server is
>> what I understand.
>>
n Tue, Jul 8, 2014 at 4:16 PM, Santhosh Thomas
wrote:
> how did you start hive? Use hive-server2
>
> ------
> *From:* Sarath Chandra
> *To:* user@hive.apache.org
> *Sent:* Tuesday, July 8, 2014 4:02 PM
> *Subject:* Issue while running Hive 0.13
&
Sources(ConnectionFactoryImpl.java:238)
at
org.datanucleus.store.rdbms.ConnectionFactoryImpl.initialiseDataSources(ConnectionFactoryImpl.java:131)
at
org.datanucleus.store.rdbms.ConnectionFactoryImpl.(ConnectionFactoryImpl.java:85)
... 64 more
~Sarath
and do all other operations on
this table.
So looks like I'm not using the right way to load the CSV files.
Can anyone throw some light here?
Regards,
Sarath.
On Friday 28 September 2012 03:14 PM, MiaoMiao wrote:
When creating external table with location clause, you need to put
your csv int
atching path
hdfs://master:54310/user/hduser/dumps/table_dump.csv/
What is going wrong? Is there a different way to load a CSV file using hive?
Regards,
Sarath.
-mkdir //usr/lib/hive/lib/
/$ hadoop fs -put $HIVE_HOME/lib/hive-builtins-0.8.1-cdh4.0.1.jar
///usr/lib/hive/lib/
Your queries should work now.
On Sep 25, 2012, at 6:46 AM, Manish.Bhoge <mailto:manish.bh...@target.com>> wrote:
Sarath,
Is this the external table where you have ran the qu
g looked on HDFS as the exception suggests. Run the
following commands:
$ hadoop fs -mkdir //usr/lib/hive/lib/
/$ hadoop fs -put $HIVE_HOME/lib/hive-builtins-0.8.1-cdh4.0.1.jar
///usr/lib/hive/lib/
Your queries should work now.
On Sep 25, 2012, at 6:46 AM, Manish.Bhoge <mailto:manish.bh...@tar
machine then looks like I
don't have enough choice.
On Tue, Sep 18, 2012 at 11:21 AM, Sarath <
sarathchandra.jos...@algofusiontech.com> wrote:
> No I don't see any antlr jars in the output. Infact not even the default
> version that exists in the hive lib folder.
> Do I need
. See if you can spot antlr jar
versions in it.
On Mon, Sep 17, 2012 at 10:40 PM, Sarath
<mailto:sarathchandra.jos...@algofusiontech.com>> wrote:
Thanks for the quick reply. Tried it. But same issue.
Pointed system to JDK 1.6 (update 32).
Changed hadoop conf to use t
o make any changes in hive->conf
folder?
On Tuesday 18 September 2012 10:35 AM, Ashutosh Chauhan wrote:
Only thing which is different then usual setups is jdk1.7 Is it
possible for you to test with jdk1.6 ?
Ashutosh
On Mon, Sep 17, 2012 at 10:02 PM, Sarath Chandra
<mailto:s
doop 1.0.3 / hive 0.9.0?
Regards,
Sarath.
On Tue, Sep 18, 2012 at 9:00 AM, Joshi, Rekha wrote:
> Hi Sarath,
>
> Sorry for delay – I don't see this mail folder all the time.
>
> Anyhow do try with exactly antler 3.4.1 – available at
> http://www.antlr.org/wiki/display/A
From ANTLR site downloaded the latest JAR -> antlr-3.4-complete.jar.
Copied this to lib folder and tried again. Same issue persists.
Thanks,
Sarath.
On Monday 17 September 2012 04:42 PM, Joshi, Rekha wrote:
Try with antlr 3.4.1 jar?
Thanks
Rekha
From: Sarath <mailto:sarathchand
t using Hive?
Please guide me.
Regards,
Sarath.
26 matches
Mail list logo
