You are viewing a plain text version of this content. The canonical link for it is here.
Posted to infrastructure-issues@apache.org by "Gavin (JIRA)" <ji...@apache.org> on 2016/03/24 13:19:25 UTC

[jira] [Closed] (INFRA-11535) how to identify same columns from multiple tables in hive

     [ https://issues.apache.org/jira/browse/INFRA-11535?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Gavin closed INFRA-11535.
-------------------------
    Resolution: Invalid

This is not the HIVE project

> how to identify same columns from multiple tables in hive
> ---------------------------------------------------------
>
>                 Key: INFRA-11535
>                 URL: https://issues.apache.org/jira/browse/INFRA-11535
>             Project: Infrastructure
>          Issue Type: Bug
>          Components: Analysis
>            Reporter: AKIF CAKIR
>            Assignee: Gavin
>
> Hi I have question about hive.
> assume there are t2 tables t1 and t2. t1 and t2 have same columns t1: emp_id, name, salary, adress 1, a, 100, f
> t2: emp_id, name, org, product 1, trk, as, dss
> and when I want to select these tables like select *from t1,t2 join .....
> hive birng me all columns but I am not able to identify which name columns come from which table.
> please help, Thank you very much for your interest.
> Akif 



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)