Bals's right, you can execute any shell command in hive-cli by using
"!shell_command;"
On Fri, Jan 2, 2015 at 4:30 AM, Bala Krishna Gangisetty
wrote:
> "!clear" is an another option too.
>
> --Bala G.
>
> On Thu, Jan 1, 2015 at 12:23 PM, Mohan Krishna
> wrote:
>
>> Hi Louis
>>
>> I use "Ctrl+
Hi,
A1: Are all of these commands (Step 1-5) from the same Hive CLI prompt?
Yes
A2: Would you be able to check if such a file exists with the same path, on
the local file system?
The file does not exist on the local file system.
Is there a way to set the another “tmp" folder for HIVE? or a
"how does vertica compare with Hive in similar settings"
Vertical in hive do no have similar settings. Vertica is a columnar MPP
analytic database. Hive is an SQL on hadoop platform. Depending on your
usage patterns you can use these things interchangeably but not all.
Vertica can do low latency <
Sorry Edward, I mentioned that I didn't have access to vertica , but yes I
was given vertica query retrieval time . Query is kind of select a.x, b.y
from t as a , t1 as b where a.id = b.id etc and the schema for those
tables required for the join were given.
A subset of the data was given and I
Shashi,
Your questions are too broad, and you are asking questions that are
impossible to answer.
Q. "What is faster X or Y?".
A. "This depends on countless variables and can not be answered."
For one example even databases that are very similar in nature like
mysql/postgres might execute a query
Edward,
Thanks for your reply.
Can you please tell me the query performance of Hive-parquet against
Vertica. Can Hive -parquet match against Vertica's retrieval performance,
as I have been told Vertica is also compressed columnar format and is fast?
What if I query against some 50 millions of rows
Hive is the only system that can store and query xml directly, with the
help of different serde's or input formats.
Impala and Vertical have more standard schema systems that do not support
Collections like List, Map, Struct or nested collections you might need to
store and process a complex XML
Hi,
Can someone help me with insights into Hive with parquet vs Vertica
comparison.
I need to store large xml data into one these database so please help me
with query performance.
Is Impala opensource and can we use it without Cloudera license.
Thanks
Shashi
