Any hive+parquet user/dev to address this?
Regards,
Mohammad
On Monday, October 5, 2015 3:41 PM, Mohammad Islam wrote:
Hi,
Does the parquet table support auto casting to wider data types? For example,
If I have a parquet table where some parquet data files which have "int" as
data type a
Hello -
While surfing the code in "apply" function of CalcitePlannerAction
(CalcitePlanner.java), I see that most rules are passed to a HepPlanner to
arrive at the "least cost" operator tree.
The HiveVolcanoPlanner although defined and initialized is never invoked to
find the best operator tree.
Hello all,
The product I work on using the HCatalog api (particularly HCatClient) to
interact with Hive. It provides virtually everything we need, with the
exception of the ability to truncate a table. I'm able to do it via the CLI by
simply issuing the "TRUNCATE TABLE" command, but HCatalog
He fully qualify query should be as
select master_request_tab.date_key, master_request_tab.ref, '' from
master_request_tab
left join dm_search_eng on substr(master_request_tab.ref, 1,
length(dm_search_eng.engine)) = dm_search_eng.engine where dm_search_eng.engine
is null;
and still showing er
Try using alias qualified columns fir common columns in bith
tables...something like this one
select date_key,ref, '' from master_request_tab a left join dm_search_eng b
on substr(ref, 1,length(a.engine)) = b.engine where a.engineis null;
On Oct 6, 2015 9:19 AM, "Garry Chen" wrote:
> Hi All,
>
>
Hi All,
Do you guys see any error in the following left join sql
statement? However, the hive give me error as "Error: Error while compiling
statement: FAILED: SemanticException [Error 10017]: Line 1:75 Both left and
right aliases encountered in JOIN 'engine' (state=42000,code=
