If you have a defined table, then loading partial columns will be easiest handled with inserting the rest columns with NULL value after mapping your partial column file as an external table.
regards Devopam On Wed, Jul 30, 2014 at 2:49 PM, CHEBARO Abdallah < abdallah.cheb...@murex.com> wrote: > I am only using Hive and hadoop, nothing more. > > > > *From:* Devopam Mittra [mailto:devo...@gmail.com] > *Sent:* Wednesday, July 30, 2014 12:15 PM > > *To:* user@hive.apache.org > *Subject:* Re: SELECT specific data > > > > Are you using any tool to load data ? If yes, then the ETL tool will > provide you such options. > > If not, then please explore unix file processing/external table route. > > > > On Wed, Jul 30, 2014 at 2:09 PM, CHEBARO Abdallah < > abdallah.cheb...@murex.com> wrote: > > Hello, > > > > Thank you for your reply. > > > > Consider we have data divided into 5 columns (col1, col2, col3, col4, > col5). > > So I can’t load directly col1, col3 and col5? > > If I can’t do it directly, can you provide me with an alternate solution? > > > > Thank you. > > > > *From:* Nitin Pawar [mailto:nitinpawar...@gmail.com] > *Sent:* Wednesday, July 30, 2014 11:37 AM > *To:* user@hive.apache.org > *Subject:* Re: SELECT specific data > > > > you mean just by writing query then I think no. > > > > But if you want to read only first 3 columns of the data then it would > work with just a single table and load data into > > > > On Wed, Jul 30, 2014 at 1:47 PM, CHEBARO Abdallah < > abdallah.cheb...@murex.com> wrote: > > Hello, > > > > I am interested in selecting specific data from a source and loading it to > a table. For example, if I have 5 columns in my dataset, I want to load 3 > columns of it. Is it possible to do it without create a second table? > > > > Thank you > > ******************************* > > This e-mail contains information for the intended recipient only. It may > contain proprietary material or confidential information. If you are not > the intended recipient you are not authorised to distribute, copy or use > this e-mail or any attachment to it. Murex cannot guarantee that it is > virus free and accepts no responsibility for any loss or damage arising > from its use. If you have received this e-mail in error please notify > immediately the sender and delete the original email received, any > attachments and all copies from your system. > > > > > > -- > Nitin Pawar > > ******************************* > > This e-mail contains information for the intended recipient only. It may > contain proprietary material or confidential information. If you are not > the intended recipient you are not authorised to distribute, copy or use > this e-mail or any attachment to it. Murex cannot guarantee that it is > virus free and accepts no responsibility for any loss or damage arising > from its use. If you have received this e-mail in error please notify > immediately the sender and delete the original email received, any > attachments and all copies from your system. > > > > > > -- > Devopam Mittra > Life and Relations are not binary > > ******************************* > > This e-mail contains information for the intended recipient only. It may > contain proprietary material or confidential information. If you are not > the intended recipient you are not authorised to distribute, copy or use > this e-mail or any attachment to it. Murex cannot guarantee that it is > virus free and accepts no responsibility for any loss or damage arising > from its use. If you have received this e-mail in error please notify > immediately the sender and delete the original email received, any > attachments and all copies from your system. > -- Devopam Mittra Life and Relations are not binary
