Hello I am using Drill latest version (1.9) in window in embedded mode.
I am trying to convert Date to Timestand. While Coverting I am using following
query:-
SELECT T5.`Name` AS `Website Name`, T5.`Description` AS
`Description`,TO_CHAR((CAST(T5.`CreateOn` AS TIMESTAMP)), 'MM-dd- hh:mm:ss
I suggest that you try using "flatten" [1] along with the mongo db storage
plugin. I did not understand what you meant by "entities could be offered
to QlikSense as if it were different tables". Below is an example of
flatten usage
select d.id, flatten(d.doc.files), d.doc.requestId from (
sel
I believe you have to re-write your sqlserver procedures leveraging the
CTAS/DROP commands of drill keeping in mind that drill does not support
INSERT/UPDATE commands.
[1] https://drill.apache.org/docs/create-table-as-ctas/
[2] https://drill.apache.org/docs/drop-table/
- Rahul
On Wed, Jan 18, 20
Hello, fellow Apache enthusiast. Thanks for your participation, and
interest in, the projects of the Apache Software Foundation.
I wanted to remind you that the Call For Papers (CFP) for ApacheCon
North America, and Apache: Big Data North America, closes in less than a
month. If you've been puttin
Hi,
I’d like to use Apache Drill to feed a QlikSense application from a MongoDB
database.
I’m not very sure about how should I manage list type attributes.
I have a MongoDB collection containing entities like this example, where a
“response” contains a list of “docs”, and each doc has a list o
Thanks a lot but this doesn't entirely solve my problem.
Is there a way to pass an *array* of parameters instead ? As in: SELECT
my_udf*([*column1, column2*])* from cp.`employees.json`
It will eventually be a single parameter, but will hold the values I need.
I tried so but I couldn't find a vali
Hello
I want to know how to use stored procedure and function in Apache
Drill.?
Does Drill Supports Procedure and Function ? & if not Is there any way to
run stored procedure and function which are stored in my Local SqlServer
through Drill.
*Thanks & Regards,*
*Sanjiv Kumar*
-
Raised this issue already in
https://issues.apache.org/jira/browse/DRILL-5109
On Wed, Jan 18, 2017 at 1:17 PM, Sanjiv Kumar wrote:
> Hello
> I am using Apache Drill latest version (1.9) in embedded mode.
>
> My Problem is :- While using over() in my query alias name changes in
> outp