Dear Abhishek,
I applied your workaround but the issue still exits .
Any idea?
best,
Paolo
Dear All,
i'm trying to open the file in attach with "Drill Explorer" but i have this
error back.
The file is quite simple.
Could you please support me?
Best regards,
Paolo
ERROR [HY000] [MapR][Drill] (1040) Drill failed to execute the query:
SELECT * FROM
;: {
"type": "text",
"extensions": [
"csvh"
],
"extractHeader": true,
"delimiter": ","
}
}
}
2016-02-20 0:15 GMT+01:00 Hanifi Gunes <hgu...@maprtech.com>:
&
tion bug.
>
> Thanks,
>
>
> [1] https://drill.apache.org/docs/troubleshooting/#enable-verbose-errors
>
>
>
> On Tue, Feb 16, 2016 at 2:45 AM, Paolino <paolosp...@gmail.com> wrote:
> > Dear all,
> > Someone could support me with this drill?
> >
> > Best
with Drill Explorer to help you do data
> discovery from a more GUI interface, but likely not exactly what you are
> looking for.
>
> --Andries
>
> > On Feb 14, 2016, at 2:56 AM, Paolo Spanevello <paolosp...@gmail.com>
> wrote:
> >
> > Dear All,
> >
&
t; '/MM/dd HH:mm:ss z') as time) from (values(1));
> +---+
> | EXPR$0 |
> +---+
> | 09:44:28 |
> +---+
> 1 row selected (0.15 seconds)
>
> --Andries
>
> > On Feb 12, 2016, at 7:15 AM, Paolo Spanevello <paolosp...@gmail.com>
> wrote:
> >
> >
Dear All,
this feature could be really helpful.
I add this image to help to understand what I would like to say.
[image: Immagine incorporata 1]
Best,
Paolo
2016-02-06 17:54 GMT+01:00 Paolo Spanevello <paolosp...@gmail.com>:
> Dear All,
>
> nobody as an answer about it. thi
Dear All,
I have a field with a date like this:
Date
2016/01/16 09:44:28 UTC
I would like to split it in Date, Time and remove "UTC".
Somebody can support me?
Best,
Paolo
Dear All,
Could i've a single query for more json files ?
Example:
- /user/folder1/file1.json
- /user/folder2/file2.json
- /user/folder3/file3.json
Query:
SELECT * FROM /user/*/file*.json
Thanks a lot for your support.
Best,
Paolo
ote:
>
> > Yes, it should work.
> >
> > On Fri, Feb 12, 2016 at 7:31 AM, Paolo Spanevello <paolosp...@gmail.com>
> > wrote:
> >
> >> Dear All,
> >>
> >> Could i've a single query for more json files ?
> >>
> >> Exam
yes with windows
2016-02-12 17:11 GMT+01:00 Zelaine Fong <zf...@maprtech.com>:
> Are you running on Windows? If so, perhaps this is DRILL-4305?
>
> -- Zelaine
>
> On Fri, Feb 12, 2016 at 8:00 AM, Paolo Spanevello <paolosp...@gmail.com>
> wrote:
>
> >
ile": {
"type": "sequencefile",
"extensions": [
"seq"
]
},
"csvh": {
"type": "text",
"extensions": [
"csvh"
],
"extractHeader": true,
workspace for persistent
> objects).
>
> When you say write the Drill do you mean creating a table or a view with
> Drill?
>
> --Andries
>
>
> > On Jan 23, 2016, at 10:47 AM, Paolo Spanevello <paolosp...@gmail.com>
> wrote:
> >
> > Dear All,
>
-c2806d3d-d500-45a8-8507-ec6af351b6ed
How is this possible enable?
Best regards,
Paolo
2016-01-23 21:01 GMT+01:00 Paolo Spanevello <paolosp...@gmail.com>:
> Dear all,
> i'm drilling with ODBC on microsoft Excel and I need to add criteria like
> in the link above:
>
>
> https://
regexp_replace to convert for these columns the "." to a "," , and see if
> that has the required performance compared to DECIMAL data conversion.
>
>
> --Andries
>
>
>
> On Jan 23, 2016, at 10:23 AM, Paolo Spanevello <paolosp...@gmail.com>
>
Dear All,
i'm using drill explorer to write the drill. I save them , when I click on
create as. When I close drill explorer and i opened it again it happen two
things:
1. the output of query is come from the query that I saved
2. The text of the SQL query is changed and it is: SELECT *
quot;,"time_in_zone_L3":"2306.0","time_in_zone_L4":"1253.0","time_in_zone_L5":"1025.0","time_in_zone_L6":"855.0","time_in_zone_L7":"270.0","percent_in_zone_L1":"27.1","percent_in_zone_L2":"15.31096","percent_in_zone_L3":"23.24362","
he KVGEN docs [1]. I have assigned the JIRA that reported this
> issue a while ago to myself and will work to improve the message [2].
>
>
> [1] - https://drill.apache.org/docs/kvgen/
> [2] - https://issues.apache.org/jira/browse/DRILL-2182
>
> On Tue, Jan 12, 2016 at 1:20 AM, P
patch that doesn't contain
> any space, for example "C:\Drill"
>
> On Tue, Sep 1, 2015 at 5:52 AM, Paolo Spanevello <paolosp...@gmail.com>
> wrote:
>
> > Nobody has a solution about this issue.
> >
> > Best,
> > Paolo
> >
>
email. Drill doesn't
support
Java 8 as the docs say. I tried to install Drill 1.1.0 on Windows 7
using
JDK 8 from Oracle to see if it would work despite lack of official
support. Drill does not start up. Sorry for the bad news.
On Saturday, August 29, 2015, Paolo Spanevello
20 matches
Mail list logo