Re: dbname.tablename does not work in desc

2011-07-18 Thread Carl Steinbach
Hi Ayon, Please see https://issues.apache.org/jira/browse/HIVE-1977 Thanks. Carl On Sat, Jul 16, 2011 at 7:22 PM, Ayon Sinha wrote: > I can do > select a.x, b.y from db1.table1 a join db2.table2 b on a.id=b.uid > > but I cannot do: > desc db1.table1 > This throws error: > hive> desc db1.table

RE: number of maptasks of hive

2011-07-18 Thread Steven Wong
What input format are you using in Hive? (It should be the one specified by the hive.input.format setting.) -Original Message- From: 牛兆捷 [mailto:nzjem...@gmail.com] Sent: Sunday, July 17, 2011 10:26 PM To: d...@hive.apache.org Subject: number of maptasks of hive Does hive split input t

Specify a SerDe for a partition

2011-07-18 Thread Roberto Congiu
Hey guys, is it possible, or are the plans of supporting, having a different serde at a partition level ? It would be useful to support data format changes. So when the serde is switched using ALTER TABLE, the new partitions will use the new serde while the old ones will continue to use the old one

RE: ODBC/JDBC Bridge

2011-07-18 Thread Guy Doulberg
If I wasn't oblige to try and make the hive cluster interact with MS reporting service, I would try to use BIRT, following this lead http://www.eclipse.org/birt/phoenix/project/notable3.7.php It seems it can provide BI/data mining/query on top of hive. Of course if you want simple query I

Re: ODBC/JDBC Bridge

2011-07-18 Thread Liam Friel
I don't, but I'd also be very interested in an answer for this issue. A search of the various fora and mailing lists did not show a definite answer, and there is an open Jira item (which I see you found :-) ) on this topic. In general what client-side BI/data mining/query tools are people using t

ODBC/JDBC Bridge

2011-07-18 Thread Guy Doulberg
Hi, I am trying to enable my clients to use MS Reporting Service (That is their demand), I tried to configure this ODBC/JDBC bridge: http://www.easysoft.com/products/data_access/odbc_jdbc_gateway/index.html With no success of obtaining license key (seems like this company has vanished from ea