what is content of your hive-env.sh ?
*Warm Regards_**∞_*
* Shashwat Shriparv*
[image:
http://www.linkedin.com/pub/shashwat-shriparv/19/214/2a9]<http://www.linkedin.com/pub/shashwat-shriparv/19/214/2a9>[image:
https://twitter.com/shriparv] <https://twitter.com/shriparv>[
Where was your meta data in derby or MySql?
*Warm Regards_**∞_*
* Shashwat Shriparv*
[image:
http://www.linkedin.com/pub/shashwat-shriparv/19/214/2a9]<http://www.linkedin.com/pub/shashwat-shriparv/19/214/2a9>[image:
https://twitter.com/shriparv] <https://twitter.com/shriparv>[
Check for errors in hive logs too if any and let us know
*Warm Regards_**∞_*
* Shashwat Shriparv*
[image:
http://www.linkedin.com/pub/shashwat-shriparv/19/214/2a9]<http://www.linkedin.com/pub/shashwat-shriparv/19/214/2a9>[image:
https://twitter.com/shriparv] <https://twitter.com
Check if hive server is running and not stopped.
*Warm Regards_**∞_*
* Shashwat Shriparv*
[image:
http://www.linkedin.com/pub/shashwat-shriparv/19/214/2a9]<http://www.linkedin.com/pub/shashwat-shriparv/19/214/2a9>[image:
https://twitter.com/shriparv] <https://twitter.com/shripa
Great Josh, it worked for you thnx :)
*Warm Regards_**∞_*
* Shashwat Shriparv*
[image:
http://www.linkedin.com/pub/shashwat-shriparv/19/214/2a9]<http://www.linkedin.com/pub/shashwat-shriparv/19/214/2a9>[image:
https://twitter.com/shriparv] <https://twitter.com/shriparv>[
Because when you do select * the query just has to read and return the
resultl but when you give query under query suffle sort and comparison
happens thats why mapreduce...
*Warm Regards_**∞_*
* Shashwat Shriparv*
[image:
http://www.linkedin.com/pub/shashwat-shriparv/19/214/2a9]<h
Thanx Nitin, we will let know once it works.. thanx alot for your
responses. :)
*Thanks & Regards*
∞
Shashwat Shriparv
On Mon, Aug 5, 2013 at 12:53 PM, Nitin Pawar wrote:
> Yes.
> Please add these two to hive-site.xml
>
> stop your application
> start hive metastore
Actually this is a production server and i cant frequently change, i was
working perfectly in morning,
On Sat, Aug 3, 2013 at 5:55 PM, Nitin Pawar wrote:
> datanucleus.fixedDataStore=true
*Thanks & Regards *
∞
Shashwat Shriparv
jdbc connection.
i am able to to connect to the sql machine and db from the machine where i
am running hive.
*Thanks & Regards*
∞
Shashwat Shriparv
try following links and let us know if it is working fine..
http://stackoverflow.com/questions/16154060/failed-error-in-metadata-java-lang-runtimeexception-unable-to-instantiate-org
*Thanks & Regards*
∞
Shashwat Shriparv
On Mon, Jul 22, 2013 at 3:48 PM, Maheedhar Reddy wrote:
username
javax.jdo.option.ConnectionPassword
passwore
*Thanks & Regards*
∞
Shashwat Shriparv
On Sat, Jun 22, 2013 at 2:26 AM, kulkarni.swar...@gmail.com <
kulkarni.swar...@gmail.com> wrote:
> More often than not in my experience is caused by a malformed
> hive-
Set the hive class path correctly.
*Thanks & Regards*
∞
Shashwat Shriparv
On Mon, May 13, 2013 at 1:10 PM, gautier vivard wrote:
> Hey,
>
> I'm beginner in the hadoop world, and more specifically in Hive (I work on
> hive-0.9.0 on Ubuntu). I work on MapR M3 in
important question i have does the amount of disk
available for map reduce or in /tmp directory is important for faster map
reduce?
--
∞
Shashwat Shriparv
>
>
>
>
> i have attached log file,which says that
>
> 2012-10-29 17:29:11,580 INFO org.apache.hadoop.ipc.Client: Retrying
> connect to server: localhost/127.0.0.1:54310. Already tried 0 time(s).
> 2012-10-29 17:29:12,581 INFO org.apache.hadoop.ipc.Client: Retrying
> connect to server: localhost/127.0.0.1:54310. Already tried 1 time(s).
> ...continued.
>
> which port should i give to hive ?
>
--
∞
Shashwat Shriparv
One try you can give. As you run a hive query it in turn runs
a map-reduce at server, over there you can capture the progress of that map
and reduce percentage and send client side for progress bar or feedback
Regards
∞
Shashwat Shriparv
On Mon, Sep 17, 2012 at 9:47 AM, MiaoMiao wrote
doop.io.SequenceFile$Reader.getCurrentValue(SequenceFile.java:1787)
>>
>> at
>> org.apache.hadoop.mapred.SequenceFileRecordReader.getCurrentValue(SequenceFileRecordReader.java:103)
>>
>> at
>> org.apache.hadoop.mapred.SequenceFileRecordReader.next(SequenceFileRecordReader.java:78)
>>
>> at
>> org.apache.hadoop.hive.ql.io.HiveRecordReader.next(HiveRecordReader.java:67)
>>
>> at
>> org.apache.hadoop.hive.ql.io.HiveRecordReader.next(HiveRecordReader.java:33)
>>
>> at
>> org.apache.hadoop.mapred.MapTask$TrackedRecordReader.moveToNext(MapTask.java:215)
>>
>> ... 9 more
>>
>>
>>
>>
>> Can anyone suggest me what does *Caused by: java.io.EOFException *means
>> here? And when I ran the same query for different date (dt), then it works
>> fine.
>>
>
>
--
∞
Shashwat Shriparv
Apache
*Hadoop*<https://microstrategy.com/news/pr_system/press_release.asp?ctry=167&id=2075>
- Cloudera is also doing something with Quest team-
http://www.theregister.co.uk/2010/06/21/cloudera_and_quest_team_on_oracle_connector/
Regards
∞
Shashwat Shriparv
On Mon, Jul 23, 2012 at 11:26
Check this link and follow :
http://www.mazsoft.com/blog/post/2010/02/01/Setting-up-HadoopHive-to-use-MySQL-as-metastore.aspx
Regards
∞
Shashwat Shriparv
On Fri, Jun 8, 2012 at 1:34 PM, soham sardar wrote:
> Thanks Nanda and Bejoy btw i would be greatful if u could give me the
> conn
gt;> I wrote the command without ; and then I think It works but with ; at
>>> the end of command
>>>
>>> CREATE TABLE pokes (foo INT, bar STRING);
>>>
>>> does'nt work
>>>
>>>
>>> On Tue, Jun 5, 2012 at 8:34 PM, shashwat
t;> It must be inside the or outside this?
>>
>>
>> On Tue, Jun 5, 2012 at 8:15 PM, shashwat shriparv <
>> dwivedishash...@gmail.com> wrote:
>>
>>> It will be inside hive/conf
>>>
>>>
>>> On Tue, Jun 5, 2012 at 11:43 PM, Babak
/etc/hive/conf/hive-site.xml
check out at above folder there you make changes
for help i am sending you link
https://ccp.cloudera.com/display/CDHDOC/Hive+Installation
On Tue, Jun 5, 2012 at 11:45 PM, shashwat shriparv <
dwivedishash...@gmail.com> wrote:
> It will be inside hive/conf
It will be inside hive/conf
On Tue, Jun 5, 2012 at 11:43 PM, Babak Bastan wrote:
> Thanks sShashwat, and where is this hive-site.xml
>
> On Tue, Jun 5, 2012 at 8:02 PM, shashwat shriparv <
> dwivedishash...@gmail.com> wrote:
>
>> set
>>
>> hive.m
leNotFoundException File file:/user/hive/warehouse/test does not
> exist.)
> FAILED: Execution Error, return code 1 from
> org.apache.hadoop.hive.ql.exec.DDLTask
> How can I solve this Problem?
> Thank you so much
>
--
∞
Shashwat Shriparv
0
> Subject: HADOOP_HOME
> From: babak...@gmail.com
> To: user@hive.apache.org
>
>
> Hello experts
>
> How can I set HADOOP _HOME? in which file I can find this variable? I
> should set this variable with the path in that I downloaded hadoop?
>
> thank you so much
>
--
∞
Shashwat Shriparv
0008_m_00_1&start=-8193>
> *at
> sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1305)
> *
> *at java.net.URL.openStream(URL.java:1009)*
> * at
> org.apache.hadoop.hive.ql.exec.errors.TaskLogProcessor.getErrors(TaskLogProcessor.java:120)
> *
> *... 3 more*
> *FAILED: Execution Error, return code 2 from
> org.apache.hadoop.hive.ql.exec.MapRedTask*
> *MapReduce Jobs Launched: *
> *Job 0: Map: 1 HDFS Read: 0 HDFS Write: 0 FAIL*
> *Total MapReduce CPU Time Spent: 0 msec*
> **
>
>
>
--
∞
Shashwat Shriparv
read-only permissions? This avoid business user accidental table drop.
> Metastore has table ROLES but don’t see documentation on that. Much
> appreciated if anyone can point to the documentation or share your thoughts
> on this?
>
> - Patrick
>
>
>
--
∞
Shashwat Shriparv
ported
> at
> org.apache.hadoop.hive.jdbc.HiveStatement.executeUpdate(HiveStatement.java:210)
> at TestSP.quarterTable(TestSP.java:598)
> at TestSP.main(TestSP.java:73)
> *
>
> On Thu, May 10, 2012 at 8:49 PM, shashwat shriparv <
> dwivedishash...@gmail.com> wrote:
>
>> Addit
ely
Hope this will help you..
Cheer
∞
Shashwat Shriparv
On Wed, May 9, 2012 at 12:49 AM, Kayla Schultz wrote:
> The query I'm trying to run is: select count(*) from customers;
> The table exists and there is data in it. However when I run this command
> I get the following: ht
will help you..
Cheer
∞
Shashwat Shriparv
On Thu, May 10, 2012 at 9:59 PM, Mahsa Mofidpoor wrote:
> Hi,
>
> When I want to join two tables, I receive the following error:
>
> 12/05/10 12:03:31 WARN conf.HiveConf: hive-site.xml not found on CLAS
our jdbc code.
and dont try to connect using cli when your jdbc code is running
Regards
∞
Shashwat Shriparv
On Wed, May 9, 2012 at 8:12 PM, Nitin Pawar wrote:
> this thread might give you an idea
>
> http://osdir.com/ml/hive-user-hadoop-apache/2010-06/msg00018.html
>
>
>
&
<
ranjith.raghuna...@usaa.com> wrote:
> Anyone implementing authorization and roles within their hive environment?
> If so how successful has it been?
>
> Thanks,
> Ranjith
>
--
∞
Shashwat Shriparv
Addition to my last reply ,,, come out from hive cli.. when you are going
to run your jdbc code. and dont try to connect using cli when your jdbc
code is running
Cheers
Shashwat.
On Thu, May 10, 2012 at 8:39 PM, shashwat shriparv <
dwivedishash...@gmail.com> wrote:
> For t
cted using code exit from ... bin/hiveof
if you are connected through bin/hive > then code will not connect because
i think (not sure) only one client can connect to the hive server.
do above steps hopefully will solve your problem.
Regards
∞
Shashwat Shriparv
On Thu, May 10, 2012 at
Do one thing create the same structure /Users/testuser/hive-0.9.0/
lib/hive-builtins-0.9.0.jar on the hadoop file system and den try.. will
work
Shashwat Shriparv
On Mon, May 7, 2012 at 11:57 PM, kulkarni.swar...@gmail.com <
kulkarni.swar...@gmail.com> wrote:
> Thanks for
Another reason that may be the cause this problem is that there may not be
much space on the namenode for its operation which was precisely the
problem which I faced. Clear some space for hadoop to launch its operations
and you are done.
On Fri, Apr 27, 2012 at 2:22 AM, shashwat shriparv
Check out this thread too :
http://comments.gmane.org/gmane.comp.java.hadoop.hbase.user/24098
On Fri, Apr 27, 2012 at 2:16 AM, shashwat shriparv <
dwivedishash...@gmail.com> wrote:
> The most common is that you have reformatted the namenode leaving it in an
> inconsistent sta
be replicated to 0 nodes, instead of 1
>>
>> And due to this my job get terminated. Is anything wrong while
>> configuration/running jobs?
>>
>> Can someone suggest me what could be the reason while SHUTTING DOWN the
>> Job Flow in AMazon EMR?
>>
>> Many Thanks.
>>
>>
>> --
>> Regards,
>> Bhavesh Shah
>>
>>
>
>
> --
> Nitin Pawar
>
>
--
∞
Shashwat Shriparv
>
> >
> >
> > I was wondering if it is possible to use it with the WHERE clause also.
> > For example I want to create the query:
> >
> > SELECT `employee.*` FROM employees WHERE $1 = 'Steve';
> >
> >
> >
> > where $1 represents a column that was matched by the regex. Any ideas?
> >
> >
> >
> > Thanks,
> >
> > Thomas Ryabin
> >
> >
>
>
> --
> Nitin Pawar
>
--
∞
Shashwat Shriparv
in is subject to archiving
> and review by persons other than the intended recipient. Thank you.
>
--
∞
Shashwat Shriparv
Check out this link
https://cwiki.apache.org/Hive/hiveclient.html
Regards
Shashwat Shriparv
On Thu, Apr 19, 2012 at 10:18 AM, Bhavesh Shah wrote:
> Hello Andes,
> I don't know about the HBASE,
>
> And about your ResultSet :
> You can traverse your resultset like as usually
t;
>
>
>
> I believe so. From the tutorial [1] :
>
>
> CREATE EXTERNAL TABLE page_view_stg(viewTime INT, userid BIGINT,
>page_url STRING, referrer_url STRING,
> ip STRING COMMENT 'IP Address of the User',
>country STRING COMMENT 'country of origination')
>COMMENT 'This is the staging page view table'
>ROW FORMAT DELIMITED FIELDS TERMINATED BY '44' LINES TERMINATED BY '12'
>
>
> HTH,
> Tim
>
>
> [1] https://cwiki.apache.org/confluence/display/Hive/Tutorial
>
>
>
>
>
>
> On Tue, Apr 17, 2012 at 11:20 PM, Gopi Kodumur < gkodu...@yahoo.com >
> wrote:
>
>
>
>
> Is it possible to specify enclosed by character " for fields , while
> defining external table
>
> Thanks
> Gopi
>
>
>
>
>
--
∞
Shashwat Shriparv
art the thrift server
>
> *收件人:*"user"
>
> *抄送:*****
>
> Hello,
>
> [root@localhost hive]# hive --service hiveserver
> Starting Hive Thrift Server
>
> After starting Hive Thrift Server nothing get printed on console. This
> means your server get started.
>
> Now you just run your JDBC program and let us know whether it runs or not.
>
>
> --
> Regards,
>
> Bhavesh Shah
>
>
>
>
>
>
>
>
> On Tue, Apr 10, 2012 at 6:03 PM, ylyy-1985 wrote:
>
> hi all,
>
> I do feel frustrated when starting the thrift server. I tried different
> version of hadoop(1.0.1 and 0.20.2), but when I tried 'hive --service
> hiveserver', the server hung there and printed the following info:
>
> [root@localhost hive]# hive --service hiveserver
> Starting Hive Thrift Server
> 12/04/10 20:22:50 INFO service.HiveServer: Starting hive server on port
> 1
>
> and I wait long but nothing happened. pls help, I just want to start the
> server and use jdbc to connect to hive.
>
> thanks in advanced.
>
> 2012-04-10
> --
>
> Andes
>
>
>
>
>
--
∞
Shashwat Shriparv
<><>
Hey hive is qury language for no sql, by default i dont think it can be
used for plotting graphs rather you can get data through and format it in
required shape and the plot using some api, provided
∞
Shashwat Shriparv
how the job submission part from Hive to Hadoop works and
>> any possible reason for this behaviour? Any pointers to look in to the code
>> is also appreciated.
>>
>> Regards
>> Buddhika
>>
>
>
--
∞
Shashwat Shriparv
t;
> > hive --service hiveserver
> >
> > It just prints
> >
> > Starting Hive Thrift Server
> > WARNING: org.apache.hadoop.metrics.jvm.EventCounter is deprecated. Please
> > use org.apache.hadoop.log.metrics.EventCounter in all the log4j.properties
> > files.
> >
> > And then nothing comes
> >
> > Can you guide me steps for configuring HIVE Thrift service with Hadoop
> >
> > Thanks in advance :)
> >
> >
>
>
>
>
>
> Thanks and Regards ,
--
∞
Shashwat Shriparv
n.Configuration
at java.net.URLClassLoader$1.run(URLClassLoader.java:202)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:190)
at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
at java.lang.ClassLoader.loadClass(ClassLoader.java:247)
... 36 more
Java Result: 1
Please guide me where i am missing things. i have added the jar files in my
project, i am able to create tables and fetch result from the hive shell,
the same query is give me result from the shell.
Regards
--
Shashwat Shriparv
println
> statements)
>
> sql="select * from tbl_name";
> res=stmt.executeQuery(sql);
>
> while(res.next())
> {
>S.O.P.("fields : "+res.getString(0));
> }
>
> Why it is happening I am not getting. Is anything I am doing wrong?
>
>
>
>
>
>
> --
> Regards,
> Bhavesh Shah
>
>
--
Shashwat Shriparv
+91-9663531241
+91-990059620
:04 PM, hadoop hive wrote:
> HI folks,
>
> I m facing a problem while when i fired a query through java code, its
> returns around half a million records which make the result set in hang
> state,
>
> please provide if there is any solution of that.
>
> Regards
> Vika
ease Notes are available here:
>
> https://issues.apache.org/jira/secure/ReleaseNote.jspa?projectId=12310843&version=12319268
>
> We would like to thank the many contributors who made this release
> possible.
>
> Regards,
>
> The Apache Hive Team
>
>
--
Shashwat Shriparv
*
>
> ** **
>
> Is there anything issue in the above script?
>
> ** **
>
> Please suggest
>
> ** **
>
> Regards
>
> Madhusudhana Rao. Podila
>
> ** **
>
> CAUTION - Disclaimer *
> This e-mail con
or an official statement of Barclays. Any views or
> opinions presented are solely those of the author and do not necessarily
> represent those of Barclays. This e-mail is subject to terms available at
> the following link: www.barcap.com/emaildisclaimer. By messaging with
> Barclays you cons
Happy new year to all may this year boost the development and make
it to reach to new hights... :) execuse me for last mail :)
--
Shashwat Shriparv
Happy new year my friends.Happy birghday to you many many happy returns of
the day have a great year ahead and
Happy new year to you..may the coming year brings lods of love joy
happyness and skucess to your life.
--
Shashwat Shriparv
---
shashwat shriparv wants to stay in better touch using some of Google's
coolest new
products.
If you already have Gmail or Google Talk, visit:
http://mail.google.com/mail/b-228469e911-d2ff778f81-WxMPnDDjf5iGTttf2REIqs
: javax.jdo.JDOFatalDataStoreException:
> Failed to start database 'metastore_db', see the next exception for
> details.
> NestedThrowables:
> java.sql.SQLException: Failed to start database 'metastore_db', see
> the next exception for details.
> FAILED: Execution Erro
.0.0.1 instead of ubuntu.ubuntu-domain .
>
> or Open the Hbase shell and run command 'status'.
>
> On Tue, Nov 29, 2011 at 1:34 PM, shashwat shriparv <
> dwivedishash...@gmail.com> wrote:
>
>> I have followed
>> https://cwiki.apache.org/confluence/
Hello group,
I am trying to create a table in hbase using hive as following create
statement and i am receiving following error, what may the probable reason
behind this. where exactly i need to give hbase master configuration settig
in hive. my hmaster is running fine and i can access through
ht
LASSPATH like
> (export
> CLASSPATH=$CLASSPATH:.:$HIVE_HOME/lib/*:$HADOOP_HOME/hadoop-0.20.2-core.jar)
> after doing this "$ java -cp $CLASSPATH HiveJdbcClient", it just stuck
> there!!
> It should create a table "testHiveDriverTable" in hive, but "show tables;&
lusion that the hive-site.xml config is not
> taken into consideration?
>
> Florin
>
> On 22 November 2011 21:06, shashwat shriparv wrote:
>
>> I have these versions of Hive : 0.7.1 Hbase :0.90.4 and
>> Hadoop: 0.20.203.0rc1.
>> I have configured Hive, Hadoop ad Hb
I have these versions of Hive : 0.7.1 Hbase :0.90.4 and
Hadoop: 0.20.203.0rc1.
I have configured Hive, Hadoop ad Hbase, separately i can create tables in
Hbase adn Hive(HDFS) , I need to integrate Hive with Hbase i have tried but
not working successfully.
Can you please provide me some reference o
60 matches
Mail list logo