With hive, without creating a table with full data, you can do intermediate processing like select only few columns and write into another table,
If this is something one time then you can take a look at awk or cut commands in linux and generate those files only. 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. > -- Nitin Pawar