Here is the verbose error message the query. If I query fh.`2015/12/05/22`
directly it works fine. Thanks for the help.
select count(i0) fromfh.`2015/12` where dir0 in ('05') and dir1 in
('22','23')
VALIDATION ERROR: From line 1, column 27 to line 1, column 28:
Table 'fh.
I tested on MapR Drill 1.3 and it seems to work correctly
select prod_id as prod, date_add(to_date(purchdate), 1) as date_purch from
hive.orders where prod_id > 100 group by prod_id, date_add(to_date(purchdate),
1) limit 2;
+---+-+
| prod | date_purch |
+---+-+
Nirav,
we would need some more details but this looks like a bug ... could you pls
create a JIRA along with the stack trace for this error? (it should be in
the drillbit.log file). Alternatively, set the following
in your sqlline session:
alter session set `exec.errors.verbose` = true;
and ru
R u running on distributed mode?
if yes than give hostname in place of localhost.
Regards,
Nirav
On Tue, Dec 22, 2015 at 5:04 PM, Pankaj Pandey
wrote:
> Hi Team,
>
> First of all thanks a lot for introducing such a nice technology like
> apache drill.
> I am able to integrate Mongodb and Hbase
Hi Team,
First of all thanks a lot for introducing such a nice technology like
apache drill.
I am able to integrate Mongodb and Hbase with apache drill.
But i want to integrate Mysql with apache drill but i am not able to create
plugin.
I am using below lines to create the plugins.
{
"type": "
Hi Andries
Thank you for your suggestion.
I tried creating a view instead of temporary table.
And it goes well, you know.
Thank you.
--
Miura, Masahide
> -Original Message-
> From: Andries Engelbrecht [mailto:aengelbre...@maprtech.com]
> Sent: Tuesday, December 22, 2015 1:35 AM
> To:
