Re: joining 2 tables

Thanks for your advice Stephen Sprague. On Wed, Aug 21, 2013 at 9:46 PM, Stephen Sprague wrote: > I'm not sure if you'd call that a join. that just looks like two tables > side by side in some random order. > > the only way to get that (that i can see) is if there is some kind of > function b

Re: How to perform arithmetic operations in hive

Thanks Justin Workman and Sanjay Subramanian. It worked !! On Fri, Aug 23, 2013 at 8:27 AM, Sanjay Subramanian < sanjay.subraman...@wizecommerce.com> wrote: > Yes this will work > Also arithmetic operations will work in a WHERE clause > Example > > select channel_id from keyword_impressions_l

Interpreting explain plan in hive

Hi, What are the key areas we need to check in the explain plan generated in Hive? I have checked the documentation, it's not detailed about the above question. https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Explain I have similar kind of question asked in our forum, which is unan

Re: Hive 0.11 with Cloudera CHD4.3 MR v1

For anyone interested, I have finished my blog on getting Hive-0.11.0 working with CDH4.3.0. It is a hack and can be made better but works like a charm. http://www.justinjworkman.com/big-data/hive-0-11-0-on-cloudera/ On Thu, Aug 22, 2013 at 8:29 AM, Jim Colestock wrote: > Justin, > > That woul

Re: How to perform arithmetic operations in hive

Yes this will work Also arithmetic operations will work in a WHERE clause Example select channel_id from keyword_impressions_log where header_date_partition='2013-08-21' and channel_id*10=290640 limit 10 From: Justin Workman mailto:justinjwork...@gmail.com>> Reply-To: "user@hive.apache.org

Re: Alter or Query a table with field name 'date' always get error

Yes "date" is a reserved word. My recommendations If your table is Hive managed (I.e u created the table without using EXTERNAL ) === - Then copy the data for this hive table that is on HDFS to another location - Drop the table - CREATE a EXTERNAL TABLE with filename - replace

Alter or Query a table with field name 'date' always get error

Hi: I have a table transaction3 with a field name 'date'.  That table is the target of importing table from MYSQL using Sqoop.  The table in MYSQL has a field with the field name 'date' and SQOOP does not allow column name mapping.  Therefore, the field name 'date' is kept in the transaction3

Re: ODBC driver for Excel

You can use the hortonworks odbc driver for free, it is available as an add-on - http://hortonworks.com/download/download-archives/ -Thejas On Thu, Aug 22, 2013 at 4:30 PM, Chad Dotzenrod wrote: > Trying to find an ODBC driver to use with Excel against my cluster that I > don't have to shell ou

ODBC driver for Excel

Trying to find an ODBC driver to use with Excel against my cluster that I don't have to shell out money for. Are there options? I'm using the cloudera driver for tableau and it works great! Just need a similar option for excel Sent from my iPhone

[HIVE2] Error on insert into table dejavu2 partition (ds) select from jdbc driver

Hi Guys I am getting the next error when I run an insert query from hive2 jdbc driver java.sql.SQLException: Error running query: null at org.apache.hive.jdbc.Utils.verifySuccess(Utils.java:162) at org.apache.hive.jdbc.Utils.verifySuccessWithInfo(Utils.java:150) at org.apache.hive.jdbc.HiveStat

"Case When ... Else..." Type Restriction

Hello: Can someone clarify this for me? In "CASE a WHEN b THEN c [ELSE f] END", are the following rules necessary? 1. a and b should have the same TypeInfo, or an exception will be thrown. 2. c and f should have the same TypeInfo, or an exception will be thrown. Right now, even if c is int, f i

[HIVE] Cannot perform a queries

Hi everyone, I have a CDH4 cluster running In 4 nodes. I can perform queries in Beeswax UI but If I try to perform the same query with the hive console it is not possible. I launched the console in this way: hive -hiveconf hive.root.logger=DEBUG,console and this is the output. = 13/08/22 13

Re: Hive 0.11 with Cloudera CHD4.3 MR v1

Justin, That would be much appreciated! Thanks Again, JC On Aug 22, 2013, at 9:18 AM, Justin Workman wrote: > I do have this working on CHD4.3.0 with MR1 and Kerberos. I am finishing up > a blog today explaining what was needed to get it working. I will reply with > the link later today

Re: How to perform arithmetic operations in hive

Try select emp_name, (emp_no * 10) from emp_table; Sent from my iPhone On Aug 22, 2013, at 8:14 AM, Sandeep Nemuri wrote: Hi all , Can we perform arithmetic operator on *select* command. I have a table emp_table with columns emp_name and emp_no i want to multiply the data in a emp_no

How to perform arithmetic operations in hive

Hi all , Can we perform arithmetic operator on *select* command. I have a table emp_table with columns emp_name and emp_no i want to multiply the data in a emp_no with 10 . i tryed select * from emp_table where emp_no=emp_no*10; But it did not work . Help me out Thanks in advance . --R

Re: Hive 0.11 with Cloudera CHD4.3 MR v1

I do have this working on CHD4.3.0 with MR1 and Kerberos. I am finishing up a blog today explaining what was needed to get it working. I will reply with the link later today. Justin Sent from my iPhone On Aug 22, 2013, at 6:17 AM, Jim Colestock wrote: Hello All, Sorry for not replying to the

RE: Hive 0.11 with Cloudera CHD4.3 MR v1

Hello All, Sorry for not replying to the thread, but I never received any of your responses.. Hopefully this info will help: @kulkarni.swarnim Here is the error I'm getting on task tracker for the mapper: 2013-08-21 15:34:32,491 INFO org.apache.hadoop.mapred.TaskLogsTruncater: Initializin

SerDe for CSV files

Hi all, I wrote a simple SerDe to deserialize CSV files defined as external table. The CSV files contain a header with columns names. I would like to skip the header while executing select * from my table. Example: CSV file content: a,b,c 1,2,3 4,5,6 select * from my_table; should return: 1,2,3

Special characters support in column names

Hi, Currently hive doesn't support special characters(i.e,%,$..etc) in table names. Is there any request for adding this feature? Please let me know, what do you feel about this. -- Thanks, Pandeeswaran