Hi,
I am trying to access HDFS data sources running in a remote instance from
apache drill running in my laptop. But I get the following error :
2015-08-13 06:06:48,287 [Client-1] INFO
o.a.d.j.i.DrillResultSetImpl$ResultsListener - [#2] Query failed:
On Mon, Aug 17, 2015 at 8:30 PM, Andrew Brust
andrew.br...@bluebadgeinsights.com wrote:
Thanks! Amazing how much that reminds me of writing .NET CLR functions
and aggregates for SQL Server, something I've covered in our SQL Server
book for the last 10 years.
It is similar, I think,
I tried to access the same file from another machine using hadoop cli and
am able to view the file contents. But still I did, try with another file
and issue exists.
Could there be any problem due to impersonation? As I am running drill and
zookeeper in one instance and the hadoop services in
Hello Driller,
I'm facing issues using the Filter function of Tableau with Drill : Tableau
always populates values of the filter with null.The action is translated into
2 queries within Drill :
SELECT * FROM (SELECT field FROM Table GROUP BY field ORDER BY field ASC) T
LIMIT 0
SELECT field
I think Tableau also uses the first query to fetch the structure /
metadata of the expected result set.
We have often eliminated performance issues using Tableau by hiding
the structure of queries by putting them in database views. Could that
be a possible solution here?
On 17 Aug 2015, at
Hi Matt,
We also hide as far as possible queries by creating tables and views within
Drill. As a result we only have one massive table within Tableau. This approach
proved to be efficient with this kind of BI tools.
My specific issue is about dynamic filtering within Tableau on a dimension
Hey,
I haven't seen this before - but a quick google search makes me think it's
an issue on Hadoop side (concurrency issues, permissions on file, stale
replicas, ...). Could you possibly create a copy of this file and try again?
Others can comment if they know better.
-Abhishek
On Mon, Aug 17,
The first query is meant to only capture the column info of the table/view,
thus limit 0.
What is the result of the second query of you execute it from sqlline?
What is the underlying datasource of Table in the queries?
Have not noticed the issue when working with Tableau 9.0 and Drill.
Docs:
https://drill.apache.org/docs/develop-custom-functions-introduction/
Some usable examples:
https://github.com/mapr-demos/simple-drill-functions
On Sun, Aug 16, 2015 at 11:06 PM, Andrew Brust
andrew.br...@bluebadgeinsights.com wrote:
the unusual code-embedding UDF system that Drill
Hi,
I am trying to install Drill on a Cloudera cluster by following the steps
described on the website.
https://drill.apache.org/docs/starting-drill-in-distributed-mode/
I have few questions before I start installing Drill,
1. How can I start a Drill shell on a node not in the cluster,
1. Yes. When you initiate the sqlline from the command line you specify the
zookeeper quorum in which to connect.
2. There is a WebUI for Drill. Here is a reference from the documentation:
https://drill.apache.org/docs/monitoring-and-canceling-queries-in-the-drill-web-ui/
On Mon, Aug 17, 2015 at
Hey,
You must already have access to this mailing list, so I don't think you
need to do anything further. You could refer to
https://drill.apache.org/mailinglists/ for details on
subscribing/unsubscribing to the Dev User mailing lists.
On Sun, Aug 16, 2015 at 11:13 PM, Malathi
the unusual code-embedding UDF system that Drill has
Have a good link where I could read more about that?
-Original Message-
From: Ted Dunning [mailto:ted.dunn...@gmail.com]
Sent: Monday, August 17, 2015 1:52 AM
To: user
Subject: Re: Benchmarks for Apache Drill
On Sun, Aug 16, 2015 at
Does normal date and interval arithmetic work?
It seems (from the SQL standard) that one should be able to use:
CAST(`datetime` AS TIMESTAMP) + 5 * INTERVAL '1' HOUR
(where that 5 can also be a general expression).
Daniel
Mehant Baid wrote:
Currently Drill supports casting to interval
15 matches
Mail list logo
