Re: FAILED: SemanticException [Error 10001]: Table not found answer

Hi chinna, There was no caused by exception.Only the error which I mentioned. It is SemanticException [Error 10001]: Table not found Thanks, Rishabh. On Tuesday, 1 April 2014 12:24 PM, Chinna Rao Lalam wrote: Hi,   Can you add what is the causedby excetion...or full exception. On Tue,

Hive vs Pig against number of files spawned

Hi all, I have a partitioned table in hive where each partition will have 630 gzip compressed files each of average size 100kb. If I query over these files using hive it will generate exactly 630 mappers i.e one mapper for one file. Now as an experiment i tried reading those files with pig and pig

Re: FAILED: SemanticException [Error 10001]: Table not found answer

Hi, Can you add what is the causedby excetion...or full exception. On Tue, Apr 1, 2014 at 11:09 AM, Rishabh Bhardwaj wrote: > Hi all, > I created the database 'test1' and a table 'my1' > Now with show tables in test1 , hive shell is showing my1 > but when I am trying to do, > describe my1; >

FAILED: SemanticException [Error 10001]: Table not found answer

Hi all, I created the database 'test1' and a table 'my1' Now with show tables in test1 , hive shell is showing my1 but when I am trying to do, describe my1; then this error comes: FAILED: SemanticException [Error 10001]: Table not found answer and when I execute, describe test1.my1; then the f

Re: Querying Hbase table from Hive without mounting

Hi Manju, If I am understanding correctly what you are trying to do, there is no current great to achieve that with the existing hive hbase integration. Ofcourse you can read and write data to HBase like you mentioned, but that is pretty much it. If you need more fine grained access like accessing

Re: Querying Hbase table from Hive without mounting

Usually to access Hbase from Hive, you will map Hbase table using .HBaseStorageHandler and specifying Hbase table in TBLPROPERTIES. But my question is ..I have to Access Hbase records directly . INSERT OVERWRITE TABLE top_cool_hbase SELECT name, map(`date`, cast(coolness as int)) FROM* top_cool

Re: Querying Hbase table from Hive without mounting

Can you elaborate a little on what exactly you mean by "mounting"? The least you will need to have hbase data query able in hive is to create an external table on top of it. On Mon, Mar 31, 2014 at 2:11 PM, Manju M wrote: > Without mapping /mounting the hbase table , how can I access and query >

Querying Hbase table from Hive without mounting

Without mapping /mounting the hbase table , how can I access and query hbase table ?

FAILED: SemanticException [Error 10007]: Ambiguous column reference product_class_id

Hi, I am running this query of two versions of the hive:hive-0.9 and hive-0.11 SELECT `c_53`.`product_class_id` AS `C_0`, `c_53`.`product_class_id` AS `C_1`, `c_53`.`brand_name` AS `c_43` FROM `dflo`.`product` `c_4133` LEFT OUTER JOIN ( SELECT * FROM `dflo`.`product` `c_4131` JOIN `dflo`.`product`

Re: Request for Write Access to Hive Wiki

Done. Thanks, Anthony for helping out to improve our documentation. Ashutosh On Mon, Mar 31, 2014 at 10:03 AM, Anthony Hsu wrote: > Hi, > > Could somebody grant me write access to the Hive wiki? I'd like to update > some outdated information on the Hive > Tutorial

Request for Write Access to Hive Wiki

Hi, Could somebody grant me write access to the Hive wiki? I'd like to update some outdated information on the Hive Tutorial page. My Apache Confluence username is erwaman. Cheers, Anthony