Unsubscribe Me

Hello Admin, Please unsubscribe me. Regards, Ashish Garg

Re: Behaviour of distinct clause

Simply run this query: select distinct name,age, filename from testing; you will be able to get the answer what you want. On Thu, Jun 5, 2014 at 11:53 AM, Rahul Channe wrote: > How does it matter , you are running distinct on name and age so one record is > displayed > > If you add file name i

Re: alter table add more columns

No, you can't add other partition column. you have to work with your current partitions. Best Regards. On Mon, Jun 2, 2014 at 5:22 PM, Ashish Garg wrote: > No, you can add other partition column. you have to work with your current > partitions. > Best Regards. > > > On M

Re: alter table add more columns

No, you can add other partition column. you have to work with your current partitions. Best Regards. On Mon, Jun 2, 2014 at 5:17 PM, Mohammad Tariq wrote: > Yes. > > *Warm regards,* > *Mohammad Tariq* > *cloudfront.blogspot.com * > > > On Tue, Jun 3, 2014 at 2:08

Re: HDFS Overwriting undo

hive -e "CREATE DATABASE my_stats LOCATION 'hdfs://:9000 */user/hive/warehouse/*mystats.db'" This command should be like as follows: hive -e 'Create Database my_stats' you do not need to specify the location because the default location of database is the warehouse directory. On Mon, Jun 2,

Re: HDFS Overwriting undo

Try this command: hadoop fs -ls -lrt /user/hive/warehouse/ Regards. On Fri, May 30, 2014 at 6:10 AM, Amjad ALSHABANI wrote: > Hello Everybody, > > I know that this question may concern Hadoop list but i ve made this > mistake when using Hive. > I created new database giving the location on HD

ManagedTablePartition

metadata. Is this the only benefit? Thanks and Regards, Ashish Garg

Re: Need urgent help on hive query performance

7;; This will optimize your query performance. On Fri, May 30, 2014 at 6:32 PM, wrote: > Can you please give a specific example or blog to refer to. I did not > understand > > > > *From:* Ashish Garg [mailto:gargcreation1...@gmail.com] > *Sent:* Friday, May 30, 2014 3:31 PM

Re: Need urgent help on hive query performance

try partitioning the table and run the queries which are partition specific. Hope this helps. Thanks and Regards, Ashish Garg. On Fri, May 30, 2014 at 6:05 PM, wrote: > Hi, > > > > Does anybody help urgently on optimizing hive query performance? I am > looking more Hado

Re: Control_A_Error

But, default is ^A, right? My question is why it is not taking? Is it an issue with hive version? Thanks and Regards, Ashish Garg On Thu, May 29, 2014 at 9:11 PM, Siddharth Tiwari wrote: > > You can write a SerDe to handle the control character. > > **

Control_A_Error

Can you try to fix this problem? I have a local file called mytest.txt (restored in hdfs already). The content is like this: $ cat -A HDFSLOAD_DIR/mytest.txt 49139801^A25752451^Aunknown$ 49139801^A24751754^Aunknown$ 49139801^A2161696^Anice$ To load this raw data above, I then defined the t