And Starting from hive 0.13, hive.stats.dbclass=fs by default.
So I am thinking autostats may not be related here.
Could be some other features need derby….
On Fri, Mar 6, 2015 at 6:37 PM, Jim Green wrote:
> Hi Edward,
>
> No matter if I set hive.stats.autogather=false in hive-site.xml or
> .hiv
Hi Edward,
No matter if I set hive.stats.autogather=false in hive-site.xml or .hiverc,
when I run “hive”, the derby database is still created.
# hive
hive> set hive.stats.autogather ;
hive.stats.autogather=false
# ls -altr|grep metastore_db
drwxr-xr-x 5 root root 4096 Mar 6 18:34 metastor
Make sure hive autogather stats is false . Or aetup the stats db
On Friday, March 6, 2015, Jim Green wrote:
> Hi Team,
>
> Starting from hive 0.13, if the metastore parameters are not set in
> hive-site.xml, but we set in .hiverc, hive will try to initialize derby
> database in current working d
Hi,
When I log in to hive via beeline and do show databases, I get the following
errors!
Transaction isolation: TRANSACTION_REPEATABLE_READ
0: jdbc:hive2://rhes564:1/ashehadoop> show databases;
org.apache.thrift.TApplicationException: Internal error processing
FetchResults
at
Hi Team,
Starting from hive 0.13, if the metastore parameters are not set in
hive-site.xml, but we set in .hiverc, hive will try to initialize derby
database in current working directory.
This behavior did not exist in hive 0.12.
Is it a known bug? or behavior change?
I have the repro as below:
Managed to log in. Need top provide the correct user and password
beeline
Beeline version 0.14.0 by Apache Hive
beeline> !connect jdbc:hive2://rhes564:1
scan complete in 7ms
Connecting to jdbc:hive2://rhes564:1
Enter username for jdbc:hive2://rhes564:1: hduser
Enter password f
Thanks Vaibhav
I shutdown all and rebooted the Linux host.
Started hive with hiveserver2 as follows:
hduser@rhes564::/home/hduser/jobs> hive --service hiveserver2 &
[1] 12234
hduser@rhes564::/home/hduser/jobs> SLF4J: Class path contains multiple SLF4J
bindings.
SLF4J: Found bind
Looks like you are trying to connect to HiveServer v1. Beeline is the CLI
client that is supported to work with HiveServer2. You can start HiveServer2
like this: hive --service hiveserver2 and then connect to it using beeline.
Thanks,
—Vaibhav
From: Mich Talebzadeh mailto:m...@peridale.co.uk>>
Hello Team,
I am trying to join a big table with around 30 columns with another table with
just one column.
Table A (part of the ddl):
CLUSTERED BY (
party_id)
SORTED BY (
party_id ASC,
acct_id ASC)
INTO 64 BUCKETS
Table B(part of the ddl):
CLUSTERED BY (
party_id)
SORTED BY (
part
plhql is a great initiative and will certainly help with more adoption of
the eco-system...Good job Dimtry
-r
*-r*
On Fri, Mar 6, 2015 at 1:07 AM, Dmitry Tolpeko wrote:
> run dos2unix for plhql file. Sorry for this issue, it will be fixed.
>
> Dmitry
>
> On Fri, Mar 6, 2015 at 11:27 AM, r7r
hi Vikram,
I am using Hive 0.10.0.
On Fri, Mar 6, 2015 at 2:11 AM, Vikram Dixit wrote:
> Hi Krish,
>
> Which version of hive are you using? Can you also provide the logs for
> this run?
>
> Regards
> Vikram.
>
> From: krish
> Reply-To: "user@hive.apache.org"
> Date: Thursday, March 5, 20
run dos2unix for plhql file. Sorry for this issue, it will be fixed.
Dmitry
On Fri, Mar 6, 2015 at 11:27 AM, r7raul1...@163.com
wrote:
> I type plhql --version but meet error bash: /usr/plhql/plhql:
> /bin/bash^M: bad interpreter: No such file or directory
>
> --
Hi,
I am trying to use beeline to access Hive/Hadoop.
Hive server is running on the Linux node that Hadoop is installed as
follows:
hduser@rhes564::/home/hduser/jobs> hive --service hiveserver 10001 -v &
[1] 30025
hduser@rhes564::/home/hduser/jobs> Starting Hive Thrift Server
Thi
I type plhql --version but meet error bash: /usr/plhql/plhql:
/bin/bash^M: bad interpreter: No such file or directory
r7raul1...@163.com
From: Dmitry Tolpeko
Date: 2015-02-28 04:36
To: user
Subject: PL/HQL - Procedural SQL-on-Hadoop
Let me introduce PL/HQL, an open source tool that i
Hi everyone,
does anybody know if it's possible to run a hive script with pyhs2?
Typically I will need to set the queue name (for tez) and run a query.
I see, in the example, that execute() doesn't ask for a ";" at the end of
the query, so I wonder if this is possible, since the script will have it
15 matches
Mail list logo
