Hive system catalog

[brajmohan saxena]

Hi,

Could any body please help me to know how to get the Hive system catalog
tables.
Also I am looking for a catalog table which can show me all the built in
functions list of Hive.

Thanks in advance.

Regards
Braj

Hive SQL query

[brajmohan saxena]

Hi,

Is there any SQL query or command to create server in Hive.
Also please let me know any API for creating server and retrieving server
info in JDBC.

Thanks
Braj

Hive Metadata tables of a schema

[brajmohan saxena]

Hi,

How can I access Hive metadata tables of a particular Server and Schema in
a C program or through JDBC client.

I have one application running on Client and my Hiveserver2 running on
Remote machine.

So if i provide Server name and Schema name in my client C program ,I
should be able to get all the tables belongs that Schema.

So Is there any Hive API where i can provide the Server and Schema name and
get the tables of that schema.

Thanks in advance,

Regards
Braj

Re: How to setup Hive JDBC client to connect remote Hiveserver

[brajmohan saxena]

Hi Shumin,

I did telnet

braj-laptop:bin brajmohan$ telnet 192.168.1.103

Trying 192.168.1.103...

telnet: connect to address 192.168.1.103: Connection refused

telnet: Unable to connect to remote host

Thanks

Braj

On Mon, Apr 4, 2016 at 8:41 AM, Shumin Guo <gsmst...@gmail.com> wrote:

> Can you telnet to that port?
>
> $ telnet 192.168.1.103 1
>
> On Sun, Apr 3, 2016 at 9:43 PM, brajmohan saxena <braj.saxena...@gmail.com
> > wrote:
>
>> Hi,
>>
>> Could you please tell me how to connect a simple JDBC program to remote
>> Hiveserver2 with default Derby database.
>>
>> I have Hiveserver2 running on remote machine and i am trying to run
>> simple JDBC program from client machine (
>> DriverManager.getConnection("jdbc:hive2://192.168.1.103:1/default",
>> "", ""); )
>>
>> but getting the following error.
>>
>> Error: Could not open client transport with JDBC Uri: jdbc:hive2://
>> 192.168.1.103:10001: java.net.ConnectException: Connection refused
>> (state=08S01,code=0)
>>
>> Do I need to change hive-site.xml file at server side.
>>
>> Thanks in advance
>>
>> Regards
>>
>> Braj
>>
>
>

How to setup Hive JDBC client to connect remote Hiveserver

[brajmohan saxena]

Hi,

Could you please tell me how to connect a simple JDBC program to remote
Hiveserver2 with default Derby database.

I have Hiveserver2 running on remote machine and i am trying to run simple
JDBC program from client machine (
DriverManager.getConnection("jdbc:hive2://192.168.1.103:1/default", "",
""); )

but getting the following error.

Error: Could not open client transport with JDBC Uri: jdbc:hive2://
192.168.1.103:10001: java.net.ConnectException: Connection refused
(state=08S01,code=0)

Do I need to change hive-site.xml file at server side.

Thanks in advance

Regards

Braj

ERRROR : no more data to read

[brajmohan saxena]

Hi,

While trying to connect to Hive server ( port 1 ) on Hortonworks
sandbox  through simple Thrift program ( transport->open(); ) I am getting
this error.

*ERROR: No more data to read.*

could you please let me know the reason for this, and from which Hive
versoin onwards this error started.

Thnaks
Braj