CODEWITHSUNDEEP
sshhive
yahoo
yahoo

Reputation: 331

Can we Run hive query using SSH and passing file from local

I want to Run hive query from external cluster like below.

ssh user@<ipaddress> hive -f <localfilepath>

It works successfully if we have file on the cluster but wont work for local file.

Is there way to achieve this ?

Upvotes: 0

Views: 293

Answers (1)

F.Lazarescu
F.Lazarescu

Reputation: 1385

From the logical point of view, immediatly after the command "ssh user@" you are "inside" that host. So you can't see the files from external cluster.

You could do it in two steps:

  1. push the file to cluser

  2. execute it

Upvotes: 1

Related Questions