I created a 3 node Hadoop cluster with 1 namenode and 2 datanode. I can perform a read/write query from Hive shell, but not beeline. I found many suggestions and answers related to this issue. In...

I am trying to export my hive table as a csv in beeline hive. When I run the command !sql select * from database1 > /user/bob/output.csv it gives me syntax error. I have successfully connected ...

I wrote a spark job which registers a temp table and when I expose it via beeline (JDBC client) $ ./bin/beeline beeline> !connect jdbc:hive2://IP:10003 -n ram -p xxxx 0: jdbc:hive2://IP> sho...

Having some databases and tables in them in Hive instance. I'd like to show tables for some specific database (let's say 3_db). +------------------+--+ |  database_name   | +------------------+--...

I'm trying to connect to hive using beeline !connect jdbc:hive2://localhost:10000 and I'm being asked for a username and password Connecting to jdbc:hive2://localhost:10000' Enter username for ...

I have a hadoop cluster configured with hadoop 2.7.2 and hive 2.1.0. I am using beeline to connect to hive with the following command: beeline beeline> !connect jdbc:hive2://localhost:10000 En...

I am trying to connect to hive installed in my machine through Beeline client. when I give the 'beeline' command & connect to Hive, the client is asking for user name & password !connect j...

I am using CDH 5.5 and need to use beeline. I am pretty new to it and learning it now. I can start beeline but cannot quit as we do in Hive. I need to use Ctrl+z to quit which is not the proper way...

I'm on a Mac OSX machine and I'd like to run queries against a Hadoop db on a CentOS 6.6 machine. I can log in to the CentOS machine and run hive queries there. But I need to be able to run queries...

I want to print this output +------------------------------------------------+--+ | tab_name | +------------------------------------------------+--+ | table1 | | table2 | | table3 | | wt | | wa |...

While using hive in beeline an using simple select query I would like to return table without table name in column name as a default. Example Data On example of a simple table (TutorialsPoint): ...

I'm running hive 2.1.1, hadoop 2.7.3 on Ubuntu 16.04. ps aux | grep hive shows that hiveserver2 is running. I'm trying to login with user [hive2] and password [password] to hivesever2 through bee...

We know that set command is used to set some values for properties hive> SET hive.exec.dynamic.partition=true; hive> SET hive.exec.dynamic.partition.mode=non-strict; But how do we read ...