hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Edward Capriolo <edlinuxg...@gmail.com>
Subject Re: Hive Database Links
Date Thu, 20 Nov 2014 18:38:35 GMT
You do not need any special features for this assuming the two clusters
have access to each other.

create table (whetaver ) location hdfs://othercluster/a

You probably want to create the table as EXTERNAL otherwise dropping it
would delete data!


On Thu, Nov 20, 2014 at 1:16 PM, Venkat, Ankam <Ankam.Venkat@centurylink.com
> wrote:

>  I have DB1.TABLE1 on CLUSTER1 and DB2.TABLE2 on CLUSTER2.
>
>
>
> I want to join these two tables from a BI tool.
>
>
>
> Is there a way to do it?
>
>
>
> Regards,
>
> Venkat Ankam
>
>
>
> *From:* Venkat, Ankam
> *Sent:* Wednesday, November 19, 2014 2:25 PM
> *To:* 'user@hive.apache.org'
> *Subject:* Hive Database Links
>
>
>
> Is there a concept of creating database links in Hive?
>
>
>
> I see a jira https://issues.apache.org/jira/browse/HIVE-2989 but not sure
> what’s the status of it.
>
>
>
> Regards,
>
> Venkat
>
> This communication is the property of CenturyLink and may contain
> confidential or privileged information. Unauthorized use of this
> communication is strictly prohibited and may be unlawful. If you have
> received this communication in error, please immediately notify the sender
> by reply e-mail and destroy all copies of the communication and any
> attachments.
>  This communication is the property of CenturyLink and may contain
> confidential or privileged information. Unauthorized use of this
> communication is strictly prohibited and may be unlawful. If you have
> received this communication in error, please immediately notify the sender
> by reply e-mail and destroy all copies of the communication and any
> attachments.
>

Mime
View raw message