I figured out what was happening.
As default, in ubuntu, mysql has the bind-address set to localhost.
So you need to go into /etc/mysql/my.cnf and comment the line: bind-address =
127.0.0.1
Robert
On Thursday, August 28, 2014 3:32 PM, Grandl Robert wrote:
Hi guys,
I was trying to conf
2014-08-29 11:19 GMT+08:00 胡齐忠 :
> Why each time to perform"add role "?
>
> nvalidObjectException(message:Role public already exists.)
>
> at org.apache.hadoop.hive.metastore.ObjectStore.addRole(ObjectStore.java:3020)
>
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>
> at
> sun.
I collect data from a real-time system, we have not another database.
2014-08-29 0:59 GMT+08:00 Venkat V :
> Have you tried sqoop merge?
>
>
> On Thu, Aug 28, 2014 at 7:45 AM, 王洋 wrote:
>
>> Hello,
>> I have two table ,one is stored as textfile for loading data from
>> local data, the othe
It takes effect when i use "alter table tablename concatenate" after a
insert sql
thanks
2014-08-29 0:44 GMT+08:00 Prasanth Jayachandran <
pjayachand...@hortonworks.com>:
> Hi
>
> If its an rcfile you can use "alter table tablename concatenate" to merge
> them into 1 file. For text files, you ca
Hi all
my hive version is 0.13.1.
Execute the following command
hive --hiveconf hive.root.logger=DEBUG,console
get Exception message:
InvalidObjectException(message:Principal www already has the role admin)
at org.apache.hadoop.hive.metastore.ObjectStore.grantRole(ObjectStore.java:3050)
at sun
Hi guys,
I was trying to configure the metastore database, following the steps:
1. sudo apt-get install mysql-server
2. sudo service mysql start
3. sudo apt-get install libmysql-java
-> copied /user/share/java/libmysql-*.jar to $HIVE_HOME/lib
4.
sudo /usr/bin/mysql_secure_installation
[...]
Ent
Hi Guys,
In this query:
select min(YYY), max(YYY) from where trim(YYY) is not null and
trim(YYY)<>'';
we expect the following result:
#42684 ZYP7250455
Column 'YYY' is of type 'string' the file format is ORC with Snappy
compression.
However we get:
ZYP7250455
(empty for the minimum)
Have you tried sqoop merge?
On Thu, Aug 28, 2014 at 7:45 AM, 王洋 wrote:
> Hello,
> I have two table ,one is stored as textfile for loading data from
> local data, the other is stored as rcfile for compressing data。
> when I execute the following sql two times
>
> * insert into tabl
Hi
If its an rcfile you can use "alter table tablename concatenate" to merge them
into 1 file. For text files, you can may have to reload these 2 files into
another table with "Order By". This will force one reducer to generate total
ordering and thereby generating 1 output file. But remember i
Hello,
I have two table ,one is stored as textfile for loading data from
local data, the other is stored as rcfile for compressing data。
when I execute the following sql two times
* insert into table tablename1 select * from tablename2*
I find that there are two files in the wa
Hello,
We are on hive 0.11. We have used hive-hbase handler to read / write
data from hbase.
We have query like
Select *
from a
join ext_b b ON a.x = b.y
join ext_c c ON a.p = c.p
One of the join tables (ext_c) is small and we wanted it to be
converted to map join. However, we observ
11 matches
Mail list logo