15/03/18 22:54:46 [main]: WARN metastore.RetryingMetaStoreClient:
MetaStoreClient lost connection. Attempting to reconnect.
org.apache.thrift.transport.TTransportException
at
org.apache.thrift.transport.TIOStreamTransport.read(TIOStreamTransport.java:132)
at org.apache.thrift.transport.TTrans
Thanks a lot for your answer, Alan!
17.03.2015, 18:20, "Alan Gates" :
> This feature is not available in Hive 1.1. It will be added in 1.2 (it has
> already been checked into trunk). In 1.1 and previous your values clause has
> to contain a value for every column in the table in the proper ord
I have a json document that has several sub documents. I can query this doc and
pull out numbers from a repetitive subdocument. The result is a list within
brackets. I want to sum these numbers, and cannot figure out how.
Here is a sample document.
{ "_id": "005f2c46-4a70-4fed-a8e9-a44
we did empirical test on a partitioned table with ~50 million rows, and
filtering from a view (which includes an explode() on an array column) vs
filtering the underlining table on a specific partition yielding similar
results.i also noticed that an "explain dependency" statement on both the vie
This feature is not available in Hive 1.1. It will be added in 1.2 (it
has already been checked into trunk). In 1.1 and previous your values
clause has to contain a value for every column in the table in the
proper order. So you would change your insert below to be
insert into person values
I have just installed and configured Apache Hive version 1.1.0. Then I have
created a table by quering this query:
create table person (name1 string, surname1 string);
And then I want to add one row by:
insert into person (name1, surname1) values ("Alan", "Green");
And it cause an error:
Err
Hive manual says that hive don't support "no two aggregations can have
different DISTINCT columns". I think theoretically it is possible to
implement this, is there any specific reason for that ? Performance reason
or something else ?
