nct name, country from users_info order by country
> select name, county from users_info group by country, name
>
> all above should work unless i made a typo error :)
>
>
>
> On Wed, Jun 27, 2012 at 3:11 PM, Soham Sardar
> wrote:
>>
>> Thanks Bejoy and Nitin for r
> hive> select name from users_info group by country;
> FAILED: Error in semantic analysis: Line 1:7 Expression not in GROUP
> BY key 'name'
>
> when you run group by it needs to be present in the select columns as well
> thats what Bejoy suggested
>
> On Wed, Ju
with the columns in Group By included in Select as well.
> Something like
>
> select country,name from users_info group by country;
>
> Regards
> Bejoy KS
>
> Sent from handheld, please excuse typos.
>
> -----Original Message-
> From: Soham Sardar
> Date: Wed,
try;
FAILED: Error in semantic analysis: Line 1:7 Expression not in GROUP
BY key 'name'
I wanna know why is it failing
On Wed, Jun 27, 2012 at 10:19 AM, Soham Sardar
wrote:
> See Bejoy and Everyone ,
> I have two tables
> one users_info and one users_audit
> in hive ..
>
&g
ing
> data itself.
>
> Regards
> Bejoy KS
>
>
>
> From: Soham Sardar
> To: user@hive.apache.org; user
> Sent: Tuesday, June 26, 2012 2:23 PM
> Subject: date datatype in hive
>
> I have a native data type in mysql and i just imported it into hive
> and the data ty
I have a native data type in mysql and i just imported it into hive
and the data type of the column has now become string ..
Now i would like to know if there is any native data type in hive and
What are the pros and cons of using string type in hive rather than
(int)(thats what i expect ) type
An
1)hive> desc users_info;
OK
id int
namestring
age int
country string
gender string
bdaystring
hive> desc users_audit;
OK
id int
userid int
logtime string
Time taken: 0.079 seconds
so both of my tables are fine and has data now the first query
i have a problem with querying with the datetime format of mysql and
then it has to stored in the string format and nothing else and then
when i try to query in it say name the users who logged between 10 to
11 am in time coz i am using LIKE which matches pattern and then i
cant give like for all
in your /etc/hosts file to
> "127.0.0.1"..Also check if there is any problem with the configuration
> properties.
>
> Regards,
> Mohammad Tariq
>
>
> On Wed, Jun 20, 2012 at 2:52 PM, soham sardar
> wrote:
>> the thing is i have updated my JAVA_HOME in bo
the thing is i have updated my JAVA_HOME in both .bashrc and hadoop-env.sh
now the problem is when i try
jps is the output is
6113 NodeManager
6799 DataNode
7562 Jps
7104 SecondaryNameNode
5728 ResourceManager
and now except namenode ,all other nodes are working and when i try to give
hadoop f
now i want to know abt the export in sqoop from hdfs ;
this is my hadoop fs
hduser@XPS-L501X:~$ hadoop fs -ls
Found 11 items
drwxr-xr-x - hduser supergroup 0 2012-06-07 15:15
/user/hduser/_sqoop
drwxr-xr-x - hduser supergroup 0 2012-06-06 15:16
/user/hduser/infor
drwxr-xr-x
ED AS SEQUENCEFILE;
>
> 1. What metastore are you using?
> 2. Can you do simple command such as 'show tables;' or select * from any
> existing table?
>
> On Thu, Jun 7, 2012 at 5:41 AM, soham sardar wrote:
>
> I am not able to create a table in the hive interactive she
12 matches
Mail list logo
