Hello
I am using apache drill version 1.9 in window 10 & running in
embedded mode.
Is it possible to access files(csv, tsv, json, etc) of remote system from
my drill.
Suppose, I have two system having same environment (i.e:- window 10,
embedded mode & 1.9 version). In both the system drill
Update:
The query results are picking up the aliases now. This happened without
restarting the system.
1) What could have caused the situation?
2) What are those extra columns?
Rahul
On Sun, Dec 4, 2016 at 4:25 PM, Rahul Raj
wrote:
> I was using sqlline and web console with drill 1.9.
>
> I
That’s exactly what I was looking for. I’m working on an adapter for a BI
tool. Is there a way also see what type of storage plugin is being used?
> On Dec 4, 2016, at 20:54, Aman Sinha wrote:
>
> Charles,
> Drill does not have a metastore for tables, so unless you have defined a
> view with
Charles,
Drill does not have a metastore for tables, so unless you have defined a
view with CAST or are querying Hive tables (Hive has a metastore), the
column types are determined at run-time. Have you tried the typeof()
function ?
SELECT typeof(column) FROM dfs.`data.json` LIMIT 1;
On Sun,
Hello all,
I’m trying to figure out if there is some way to determine what types of
columns a given data source contains. It looks like this should exist in the
INFORMATION_SCHEMA somewhere, but I’m not clear how to do it.
For instance, let’s say that I have a file called data.json. I could
I was using sqlline and web console with drill 1.9.
I executed a select all on a very small csv file, but surprisingly found
few additional columns [fqn,filename,filepath,suffix] along with the array
containing the results. Then converted the results to parquet by selecting
the specific required c
I gave this a try on Windows - downloaded the 1.9.0 release and moved it to
C:\Users\agirish\apache-drill-1.9.0. I was successfully able to bring up
Drill in embedded mode. It looks like I did have read/write/execute
permissions on the dir (by default) - so I'm not sure if that's any
different from