The user mailing list tool doesn't support images. Please use text or post
images somewhere and provide a link. Thanks.
Kristine Hahn
Sr. Technical Writer
415-497-8107 @krishahn skype:krishahn
On Wed, Jan 13, 2016 at 12:06 AM, 伍晋博 <kimble_...@foxmail.com> wrote:
> Hi
> I am a be
to give it a
shot. Anything might be better than just relying on iODBC documentation.
To really simplify things for users, how about including the iODBC manager
in the Drill driver?
Kristine Hahn
Sr. Technical Writer
415-497-8107 @krishahn skype:krishahn
On Tue, Jan 5, 2016 at 9:21 AM, Jacques Nadeau
+1
Kristine Hahn
Sr. Technical Writer
415-497-8107 @krishahn skype:krishahn
On Tue, Jan 5, 2016 at 9:31 AM, Paul Ilechko <pilec...@maprtech.com> wrote:
> I don't think the issue is how to install iODBC, it's knowing that there is
> another thing that you need to install. Yes. the
Please see step 1 of
http://drill.apache.org/docs/installing-the-driver-on-windows/#step-3-verify-the-installation
"Installing the ODBC Administrator installs Drill Explorer and the Tableau
TDC file."
Kristine Hahn
Sr. Technical Writer
415-497-8107 @krishahn skype:krishahn
On Mon, J
oops, sorry, I now see you prefaced the FROM with cp. Forget that.
Kristine Hahn
Sr. Technical Writer
415-497-8107 @krishahn skype:krishahn
On Thu, Dec 31, 2015 at 2:52 PM, Kristine Hahn <kh...@maprtech.com> wrote:
> Please try USE cp; before the select statement. Drill uses the df
Please try USE cp; before the select statement. Drill uses the dfs storage
plugin, not the cp storage plugin, by default.
Kristine Hahn
Sr. Technical Writer
415-497-8107 @krishahn skype:krishahn
On Thu, Dec 31, 2015 at 2:50 PM, Peder Jakobsen | gmail <pjakob...@gmail.com
> wrote:
> I
Thanks for the feedback. We'll make the corrections you suggested right
away. Sorry for the inconvenience. We really appreciate you letting us know.
Kristine Hahn
Sr. Technical Writer
415-497-8107 @krishahn skype:krishahn
On Wed, Dec 30, 2015 at 4:07 AM, Rohit Kulkarni <rohitkulk
ing-drill-in-distributed-mode/#starting-the-drill-shell>
and with Using an Ad-Hoc Connection to Drill
<https://drill.apache.org/docs/starting-drill-in-distributed-mode/#using-an-ad-hoc-connection-to-drill>.
Fixing!
Thanks.
Kristine Hahn
Sr. Technical Writer
415-497-8107 @krishahn skype:krishah
Revised doc is published:
https://drill.apache.org/docs/starting-drill-in-distributed-mode/
Kristine Hahn
Sr. Technical Writer
415-497-8107 @krishahn skype:krishahn
On Wed, Dec 30, 2015 at 1:12 PM, Kristine Hahn <kh...@maprtech.com> wrote:
> No, I don't think that's cle
+1
Created Drill-4213.
Kristine Hahn
Sr. Technical Writer
415-497-8107 @krishahn skype:krishahn
On Fri, Dec 18, 2015 at 2:31 AM, Geercken, Uwe <uwe.geerc...@swissport.com>
wrote:
> Hello,
>
> Would it be possible to indicate a version and/or date in the
> documentation pages,
Please see the Amazon S3 Help regarding set of the xml:
fs.s3.awsAccessKeyId
ID
fs.s3.awsSecretAccessKey
SECRET
Your connection in the plugin config needs to include the URL that
looks something like this:
"connection": "s3n://:@myname",
Kristine Hahn
Sr. Tech
ult settings, when save the config,
Drill removes skipFirstLine=false when extractHeader=true. I think the docs
need to say "Ensure skipFirstLine does not = true when extractHeader=true"
instead of "Ensure skipFirstLine=false when extractHeader=true".
Kristine Hahn
Sr. Techni
was designed to be included in the open source
version and is now be reviewed for inclusion:
https://issues.apache.org/jira/browse/DRILL-3201
Kristine Hahn
Sr. Technical Writer
415-497-8107 @krishahn skype:krishahn
On Mon, Dec 7, 2015 at 11:16 AM, John Omernik <j...@omernik.com>
/Configuring+Web+Console+and+REST+API+Security
Kristine Hahn
Sr. Technical Writer
415-497-8107 @krishahn skype:krishahn
On Thu, Nov 12, 2015 at 8:06 AM, Andries Engelbrecht <
aengelbre...@maprtech.com> wrote:
> Try looking at this page
> https://drill.apache.org/docs/configuring-web-ui-
I think you're reading about the Web Console login screen on the MapR docs
<http://doc.mapr.com/display/MapR/Configuring+Web+Console+and+REST+API+Security>
web site. Currently, that feature is available on Drill on MapR version 1.2
only. We'll clarify the docs.
Kristine Hahn
Sr. Technical
Most likely, it was planned for inclusion in Drill 1.2. Right before the
release, a few issues arose, and those issues haven't been fixed yet.
Kristine Hahn
Sr. Technical Writer
415-497-8107 @krishahn skype:krishahn
On Fri, Nov 6, 2015 at 1:00 PM, Kevin Verhoeven <kevin.verhoe...@ds-iq.
Sorry I didn't get it. I'll completely remove
http://drill.apache.org/docs/json-data-model/#empty-array. Thanks guys.
Kristine Hahn
Sr. Technical Writer
415-497-8107 @krishahn skype:krishahn
On Mon, Oct 19, 2015 at 12:59 PM, John Omernik <j...@omernik.com> wrote:
> Awesome th
Thanks Onna, fixing.
Kristine Hahn
Sr. Technical Writer
415-497-8107 @krishahn skype:krishahn
On Thu, Oct 29, 2015 at 3:48 PM, Onna Nelson <onel...@maprtech.com> wrote:
> Hello,
>
> On http://drill.apache.org/docs/math-and-trig/
>
> ROUND(x, y)DECIMALRounds x to s decimal
e.org/docs/storage-plugin-registration/#storage-plugin-configuration-persistance).
Also,please take a look at
http://drill.apache.org/docs/plugin-configuration-basics/. Sorry Drill info
is not organized better.
Kristine Hahn
Sr. Technical Writer
415-497-8107 @krishahn skype:krishahn
On Tue, Oct 27, 20
ve to change the name of the file. You can query
somefile.gz file if you add the a format specification to the storage
plugin configuration as shown in
http://drill.apache.org/docs/querying-plain-text-files/#querying-compressed-files
.
Kristine Hahn
Sr. Technical Writer
415-497-8107 @krishahn sk
user/pass is incorrect though. In my case, I hadn't
> started my MySQL server (bollocks)
>
>
>
> On Sun, Oct 18, 2015 at 10:46 AM, Kristine Hahn <kh...@maprtech.com
> <javascript:;>> wrote:
>
> > What's wrong with this command?
> >
> > curl -X POS
ably
need to add a few more.
Kristine Hahn
Sr. Technical Writer
415-497-8107 @krishahn skype:krishahn
On Tue, Oct 20, 2015 at 6:53 AM, Geercken, Uwe <uwe.geerc...@swissport.com>
wrote:
> Kristine,
>
> Just a note:
>
> I tested JDBC access yesterday. What I found out is, that i
sometimes. Try removing it if you have a problem.
Kristine Hahn
Sr. Technical Writer
415-497-8107 @krishahn skype:krishahn
On Mon, Oct 19, 2015 at 1:03 PM, Andries Engelbrecht <
aengelbre...@maprtech.com> wrote:
> Word of caution that Flatten may be better as only the first may be
Thanks for explaining what's going on, Ted! I'll use the info you've
provided to clarify things in the docs.
Kristine Hahn
Sr. Technical Writer
415-497-8107 @krishahn skype:krishahn
On Mon, Oct 19, 2015 at 4:03 PM, Ted Dunning <ted.dunn...@gmail.com> wrote:
> Kristine,
>
> I jus
plication/json" --data '{"name": "myplugin4",
"config": { "type": "jdbc", "enabled": false, "driver":
"com.mysql.jdbc.Driver", "url": "jdbc:mysql://localhost:3306;" }}'
http://localhost:
it's MapR Drill only.
Kristine Hahn
Sr. Technical Writer
415-497-8107 @krishahn skype:krishahn
On Thu, Oct 15, 2015 at 2:28 PM, Christopher Matta <cma...@mapr.com> wrote:
> I can't seem to find any reference documentation around the REST API on
> https://drill.apache.org/docs/,
/1mRsuWk4Dpt6ts-jQ6ke3bB30PIwanRiCPfGxRwZEQME/edit
Kristine Hahn
Sr. Technical Writer
415-497-8107 @krishahn skype:krishahn
On Thu, Oct 15, 2015 at 4:03 PM, Christopher Matta <cma...@mapr.com> wrote:
> What about general REST API reference documentation? What endpoints are
&g
-SNAPSHOT/sample-data/donuts.json`;
> +-+
> | EXPR$0 |
> +-+
> | Powdered Sugar |
> | null|
> | null|
> | null|
> | null|
*+-+*
5 rows selected (0.108 seconds)
Kristine
lgtm
Kristine Hahn
Sr. Technical Writer
415-497-8107 @krishahn skype:krishahn
On Mon, Oct 12, 2015 at 10:45 AM, John Omernik <j...@omernik.com> wrote:
> I've created https://issues.apache.org/jira/browse/DRILL-3922 for this
> issue. I put in notes to reproduce, and why it's imp
://drill.apache.org/docs/querying-hbase/.
Kristine Hahn
Sr. Technical Writer
415-497-8107 @krishahn skype:krishahn
On Sat, Sep 12, 2015 at 12:50 AM, YiyiHu <yiyi...@hotmail.com> wrote:
> Hi,
> I' m new to drill.
> I have tried queries on HBASE like: SELECT*FROM WHERE
> L
e Hive CHAR type is mapped to the SQL VARCHAR
type, but the ramifications of this mapping with regard to using Hive don't
jump out at you. We need to spell it out using a Hive example, right?
Kristine Hahn
Sr. Technical Writer
415-497-8107 @krishahn skype:krishahn
On Fri, Sep 4, 2015 at 7
=Emailutm_medium=Signatureutm_campaign=Free%20available
--
Kristine Hahn
Sr. Technical Writer
415-497-8107 @krishahn skype:krishahn
],
COLUMNS[2]
FROM `/googlebooks-eng-all-5gram-20120701-zo.tsv`
WHERE ((columns[0] = 'Zoological Journal of the Linnean')
AND (columns[2] 250))
LIMIT 10;
Kristine Hahn
Sr. Technical Writer
415-497-8107 @krishahn skype:krishahn
On Fri, Aug 28, 2015 at 2:38 PM
Correction: save the output to a
.tbl file
Kristine Hahn
Sr. Technical Writer
415-497-8107 @krishahn skype:krishahn
On Sun, Aug 23, 2015 at 4:04 PM, Kristine Hahn kh...@maprtech.com wrote:
You can use the Drill Shell command !record to save the output to a
.tbl command and then query the PSV
You can use the Drill Shell command !record to save the output to a
.tbl command and then query the PSV results using the COLUMNS[n]
syntax, which can return the accessTime from COLUMNS[7].
Kristine Hahn
Sr. Technical Writer
415-497-8107 @krishahn skype:krishahn
On Sun, Aug 23, 2015 at 3:45 PM
We can't see the error that I guess you posted as an image. Images don't
work on the list.
Kristine Hahn
Sr. Technical Writer
415-497-8107 @krishahn skype:krishahn
On Wed, Aug 19, 2015 at 9:55 AM, Usman Ali usman@platalytics.com
wrote:
Hi,
I received following error while querying
.
**
--
Kristine Hahn
Sr. Technical Writer
415-497-8107 @krishahn skype:krishahn
Fabian--the README says to use Drill 0.9. Is that just not updated? Thanks!
Kristine Hahn
Sr. Technical Writer
415-497-8107 @krishahn skype:krishahn
On Fri, Jul 31, 2015 at 2:54 AM, Fabian Wilckens fwilck...@maprtech.com
wrote:
Hi Pankaj,
have a look: https://github.com/mapr-emea/apache
You can display the command history:
http://drill.apache.org/docs/configuring-the-drill-shell/
It persists between sessions.
Kristine Hahn
Sr. Technical Writer
415-497-8107 @krishahn
On Wed, Jul 29, 2015 at 7:20 AM, Geercken, Uwe uwe.geerc...@swissport.com
wrote:
Hi Drill Friends,
I have
Also, if you configured the ZooKeeper PStore
http://drill.apache.org/docs/persistent-configuration-storage/#configuring-zookeeper-pstore,
offloaded query profile data will be stored in the Drill log directory on
Drill nodes.
Kristine Hahn
Sr. Technical Writer
415-497-8107 @krishahn
On Wed, Jul
-drill-version/sample-data/region.parquet`;
Kristine Hahn
Sr. Technical Writer
415-497-8107 @krishahn
On Tue, Jul 28, 2015 at 3:22 AM, Anas Mesrah anas.mes...@gmail.com wrote:
Hello Everyone,
Is it possible in drill (using the file system storage plugin) to query the
matching tables
Ott
http://alexott.net/
Twitter: alexott_en (English), alexott (Russian)
Skype: alex.ott
--
Kristine Hahn
Sr. Technical Writer
415-497-8107 @krishahn
Sounds great. The docs are written in markdown and stored in github-pages.
You can contribute to the docs using a pull request. Click the pencil icon
on the top right side of the page, and go for it. Thanks much, really
appreciate your feedback and help.
Kristine Hahn
Sr. Technical Writer
415-497
:
written 153,728B for [occurred_at] INT64: 28,910 values, 231,288B raw,
153,681B comp, 1 pages, encodings: [RLE, BIT_PACKED, PLAIN]
Is that to be expected or am I missing something that needs to be done for
it to become a timestamp in Parquet?
Regards,
-Stefan
--
Kristine Hahn
Sr
*
* |*
*+-+**| *1
* |**| *2
* |*
*+-+*2 rows selected (0.096 seconds)
http://drill.apache.org/docs/json-data-model/ has more examples than the
doc page you might be using.
Kristine Hahn
Sr. Technical Writer
415-497-8107 @krishahn
On Sun, Jul 12, 2015 at 1:41 PM, Stefán Baxter ste
`;
++
|columns |
++
| [hello 1 2 3] |
| [hello 1 2 3] |
| [hello 1 2 3] |
++
3 rows selected (0.117 seconds)
Kristine Hahn
Sr. Technical Writer
415-497-8107 @krishahn
On Fri, Jun 26, 2015 at 10:02 AM
-basics/#using-the-formats
Kristine Hahn
Sr. Technical Writer
415-497-8107 @krishahn
On Fri, Jun 26, 2015 at 7:27 AM, Chi-Lang Ngo chil...@gmail.com wrote:
Hi,
I'm having problem querying tab-delimited (tsv) files which has quotes.
Drill doesn't seem to recognise quotes in tsv while
Please see http://apache.github.io/drill/docs/file-system-storage-plugin/
and please let us know if you have any problems with these instructions.
Kristine Hahn
Sr. Technical Writer
415-497-8107 @krishahn
On Tue, Jun 9, 2015 at 5:00 PM, Kartik Bhatia kbha...@scif.com wrote:
Hi,
I have
Case-sensitive I think, try all caps.
On Monday, June 8, 2015, Kristine Hahn kh...@maprtech.com wrote:
Set the UID and PWD properties in the connection string.
http://tshiran.github.io/drill/docs/odbc-configuration-reference/ has a
first draft of the docs that include a description
Setting the large and small queue to 1 would'nt do it because the queues
could be operating simultaneously, says Dev. To serialize all incoming
queries, set the small queue at 0 and the exec.queue.threshold at 0.
Kristine Hahn
Sr. Technical Writer
415-497-8107 @krishahn
On Wed, May 13, 2015
Thanks, yes it is confusing. There's some documentation on
http://drill.apache.org/docs/data-type-conversion/#time-zone-limitation
about the limitation and conversion functions, but there's lots of room for
improvement.
Kristine Hahn
Sr. Technical Writer
415-497-8107 @krishahn
On Mon, May 11
-received large query returns and the
large queue is available to continue processing large queries.
Kristine Hahn
Sr. Technical Writer
415-497-8107 @krishahn
On Thu, Apr 30, 2015 at 12:04 AM, Richard Shaw rs...@maprtech.com wrote:
I'd like to better understand queuing, if it's in fact possible
The new docs http://tshiran.github.io/drill/docs/lexical-structure/ will
say:
First paragraph, last bullet: /* This is a comment. */
Kristine Hahn
Sr. Technical Writer
415-497-8107 @krishahn
On Tue, Apr 28, 2015 at 11:23 AM, Andries Engelbrecht
aengelbre...@maprtech.com wrote:
How do you
|data|
+++
| {view:{id:n2rk-fwkj,name:Unclaimed bank
accounts,averageRating:0,category:Government,
. . .
Now, how exactly to flatten that big array is another question, answer
TBD.
Kristine Hahn
Sr. Technical Writer
415-497-8107 @krishahn
On Fri, Apr 3, 2015
Link correction:
http://apache.github.io/drill/docs/json-data-model#handling-type-differences
Kristine Hahn
Sr. Technical Writer
415-497-8107 @krishahn
On Fri, Apr 3, 2015 at 6:57 AM, Vince Gonzalez vince.gonza...@gmail.com
wrote:
Yep:
0: jdbc:drill:zk=local select jblob['v'] from (select
to [Drill Date/Time Data Type
Formats](/docs/supported-date-time-data-type-formats).
For more info, please see preliminary docs at
http://drill.apache.org/docs/json-data-model.
Kristine Hahn
Sr. Technical Writer
415-497-8107 @krishahn
On Mon, Mar 30, 2015 at 7:50 AM, Vince Gonzalez vince.gonza
Sorry, I have to miss it again. Coming in late tomorrow.
On Mon, Feb 2, 2015 at 1:56 PM, Jason Altekruse altekruseja...@gmail.com
wrote:
Hello Drillers,
Please join us tomorrow at 10am Pacific for our community meeting. If you
are new to Drill, have questions about the current work being
57 matches
Mail list logo