RE: Download URL missing

Thank you for your immediate supporting. I could download from http://mirrors.sonic.net/apache/drill/drill-1.5.0/apache-drill-1.5.0.tar.gz. -- Miura, Masahide -Original Message- From: Bridget Bevens [mailto:bbev...@maprtech.com] Sent: Wednesday, February 24, 2016 11:58 AM To:

RE: Download URL missing

Hi Does anyone help me? -- Miura, Masahide -Original Message- From: masahide.mi...@brother.co.jp [mailto:masahide.mi...@brother.co.jp] Sent: Thursday, February 18, 2016 4:28 PM To: user@drill.apache.org Subject: Download URL missing Hi, It is not available URL for download with wget

Download URL missing

Hi, It is not available URL for download with wget / curl command at version 1.4.0 or later. Such URL as http://getdrill.org/drill/download/apache-drill-.tar.gz I would like to know correct URLs for console installation. see also: https://drill.apache.org/docs/drill-in-10-minutes/

RE: REGEX search Operator

Hi, ANSI SQL doesn't define regex operator. Drill neither. Doesn't it enough 'LIKE' operator? Or, REGEXP_REPLACE/SUBSTR functions may help you. https://drill.apache.org/docs/string-manipulation/ -- Miura, Masahide -Original Message- From: Nicolas Paris [mailto:nipari...@gmail.com]

RE: JDBC Ignores URL ?

Hi, Did you try connect to drillbit URL directly? see as: https://drill.apache.org/docs/using-the-jdbc-driver/#using-the-jdbc-url-format-for-a-direct-drillbit-connection or https://drill.apache.org/docs/using-jdbc-with-squirrel-on-windows/#entering-the-connection-url -- Miura, Masahide

RE: Does drill recognize new line correctly?

For CSV: I've realized why newline is not be supported. For JSON: I mentioned WHERE clause to b in your case. escaped_break.json is same as yours. 0: jdbc:drill:zk=local> select * from `escaped_break.json` where b like 'hello%'; +++ | a | b| +++ | 4 | hello |

RE: Join with empty table

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:

Join with empty table

Hi, Is any good way to avoid error on join query with empty table? I've come across 2 types of error as bellow. Sample SQL: select A.*, B.* from cp.`tpch/nation.parquet` as A join dfs.tmp.`dummy` as B on A.n_nationkey = B.n_nationkey 1) When the table(file)

RE: rand() is not random by row

Hello, Jason Thank you for your explanation. I see how rand function goes. > Drill comes with it's own native random() function that does what you want. I didn't know it! This is what I want, as you told. Thank you so much. -- Miura, Masahide

rand() is not random by row

Hi, I found that rand() function does not reply random value. When I used it, all rows are same values through all rows. You can see this result with bellow query: select *, rand() from sys.boot limit 10 ver: 1.3.0 client: Web( drillhost:8047 ) environment: distributed on EMR Thanks. --

How to control permission of S3 access

Hi, I don't know which mailing list matches about this, but... Can we control permission to access S3 bucket or key with S3 plugin? (plugin bundled with 1.3.0, not jets3t) I'd like to control permission of S3 data by drill user; like the way of user impression for local file system. ->