--
Thanks & Regards
* Sanjiv Kumar*
Query Profile
STATE: CANCELLATION_REQUESTED
FOREMAN: X.com
TOTAL FRAGMENTS: 1
Major Fragment: 00-xx-xx
<http://192.168.10.37:8047/profiles/2755683d-810b-6588-25a3-49e09b9f4d3e#fragment-0>
On Fri, Feb 17, 2017 at 5:17 PM, Sanjiv Kumar C <sanj...@ejeeva.com> wrote:
> Dr
:- select * from <pluginName).. limit 5;
What should i do?
--
Thanks & Regards
* Sanjiv Kumar*
Hello This is my input table in db:-
State Price
Alaska 75
Texas 80
Alaska 90
Florida 100
florida 70
Sql Server Query:- select State, Sum (Price) from testTable group by State.
Sql Server Output:-
State Price
Alaska 165
Texas 80
Florida 170
Drill Query:- select T1.State, Sum(T1.Price) from
to display only upto 2 or 3 value after decimal. like (11936.36).
Is there any options are there to show upto decimal upto 2 value.?
--
Thanks & Regards.
Sanjiv Kumar.
lower and upper is not a solution which i am aspecting. I want to display
same output as i get through sql server management studio
On Wed, Feb 8, 2017 at 5:15 PM, Sanjiv Kumar <sanjiv...@gmail.com> wrote:
> Drill Environment:- OS:- Window 10
>V
are showing two seperate rows.
So how to avoid case sensitivity so that both Florida and florida act as 1
rows while firing count(Sate).?
--
Thanks & Regards.
Sanjiv Kumar.
came. Thanks for your reply
Khurram.
On Wed, Feb 8, 2017 at 3:15 PM, Sanjiv Kumar <sanjiv...@gmail.com> wrote:
> Hello I have decimal value in my table. When query through drill data are
> rounded off in output.
>
> I have enable planner.enable_decimal_data_type = true in system op
Mode:- embedded mode
--
Thanks & Regards.
Sanjiv Kumar.
Yes I have a jdbc plugin enabled.
On Tue, Jan 31, 2017 at 8:42 PM, Sanjiv Kumar <ktrsan...@gmail.com> wrote:
> Hello I am using Drill latest version (1.9) in window and in embedded mode.
>
> I have csv file in my local drive (D://). While querying through csv file
>
column are also showing
like fqn, filename,filepath, suffix columns are showing.
Please tell me how to restrict those extra column.?
*Thanks & Regards,*
*Sanjiv Kumar*
-
Hello I am again posting my question in correct format.
Hello I am using Drill latest version (1.9) in window in embedded mode.
I am trying to convert Date to Timestamp.
While Converting I am using following query:-
SELECT T5.`Name` AS `Website Name`, T5.`Description` AS
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*
-
3011-03-2016 12:00:00 AM
1005 9510-14-2016 12:00:00 AM
1006 1510-05-2016 12:00:00 AM
What is the problem with over(). ??What i am doing wrong in this query.?
Why my column name not showing ??
Thanks & Regards.
Sanjiv Kumar.
to group by at
runtime (e.g:- through code).
Is Group By Required with OVER() ??
On Tue, Jan 17, 2017 at 6:12 PM, Sanjiv Kumar <sanjiv...@gmail.com> wrote:
> Hello Arina
>
> Thanks for reply. I have tried over() it working fine with
> single table, but when i used j
:- 10) ?
ex:- select T1.Id, T1.Name, T1.Salary, Count(*) from
..
Can anyone tell the solution.??
--
Thanks & Regards.
Sanjiv Kumar.
) AS `ID`, T3.`Name` AS `Name` FROM
... AS T2 INNER
JOIN ... AS T3 ON
T3.`ID` = T2.`WebsiteID`
Output:-
Alias Name i.e ID, Name are not showing in output.Some
different column name are showing (like: ID$0, etc)
What is the problem. Is this a bug??
Thanks & Regards.
Sanjiv Kumar.
.zk.ZKClusterCoordinator.start(ZKClusterCoordinator.java:123)
at
org.apache.drill.exec.client.DrillClient.connect(DrillClient.java:243)
... 19 more
--
-------
Thanks & Regards
Sanjiv Kumar
9.0]
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
[na:1.8.0_111]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
[na:1.8.0_111]
at java.lang.Thread.run(Thread.java:745) [na:1.8.0_111]
On Tue, Jan 3, 2017 at 8:01 PM, Sanjiv Kumar <sanjiv...@gmail.com> wrote:
> Hell
have same category name in a single row
using drill query ?
Like:-
categoryName customerName
C1 Cust1,Cust3,Cust4
C2 Cust2
-
Thanks & Regards
Sanjiv Kumar
Hello
I am using drill latest version (1.9) in embedded mode in Ubuntu
system.
My query is :-
If i run query having less number of records, drill
working fine.
But If i run long query having (8124042 records), drill
stopped without throwing any error.
Hello
Wish you a happy new year.
I have a doubt.. How to access Apache Drill using REST API when
authentication and https both are enabled?
--
---
Thanks & Regards
Sanjiv Kumar
offset 10, then it working fine.
select c.CategoryID from demoPlugin.dbo.Category as c group by
c.CategoryID order by 1 desc limit ALL;
What is the problem.? Is limit all is not supported with offset?
---
Thanks & Regards
Sanjiv Kumar
are not working.Please suggest some way how to add two different
datatype columns.
--
Thanks & Regards.
Sanjiv Kumar.
Hello
I want to know how and where to configure HTTPD Storage plugin. How
it working?
Can i convert my IP address to location, country using httpd plugin.
--
---
Thanks & Regards
Sanjiv Kumar
in a
table, it will take more than an hour for showing output.
Please tell me how to speed up my drill. Is there any configuration changes
required for speeding up drill query.?
On Mon, Nov 28, 2016 at 3:18 PM, Sanjiv Kumar <sanjiv...@gmail.com> wrote:
> Hello Matt
>
>
> I
ritable": true,
"defaultInputFormat": null
}
},
"formats": {
"json": {
"type": "json",
"extensions": [
"json"
]
}
}
}
And fire Select command, but error showing.
Error: SYSTEM ERROR: IOException: No FileSystem for scheme: http
--
..
Thanks & Regards
*Sanjiv Kumar*
last column data as blank.
On Wed, Nov 30, 2016 at 11:15 AM, Sanjiv Kumar <ktrsan...@gmail.com> wrote:
> I am using latest version 1.8 and in window 10 operating system.
>
> On Tue, Nov 29, 2016 at 11:40 AM, Sanjiv Kumar <ktrsan...@gmail.com>
> wrote:
>
>> I alrea
I am using latest version 1.8 and in window 10 operating system.
On Tue, Nov 29, 2016 at 11:40 AM, Sanjiv Kumar <ktrsan...@gmail.com> wrote:
> I already pasted the csv file. Just copy and save it as csv. I am also
> attaching csv file. And the query is same as i mention above
I already pasted the csv file. Just copy and save it as csv. I am also
attaching csv file. And the query is same as i mention above.
select A.`sepalen`, A.`sepalwidth`, A.`patelen`, A.`patelwidth`, A.class
from dfs.tmp.`copydata.csv` as A;
On Mon, Nov 28, 2016 at 6:30 PM, Sanjiv Kumar <ktr
Hello Matt Keranen
It will take only few second.
--
Thanks & Regards.
Sanjiv Kumar.
Hello Matt
If i run same query in sql server directly, it will take only few seconds.
But in Drill it will take hours to show output and even some time
Connection Error (user Client) Close unexpectedly showing
--
Thanks & Regards.
Sanjiv Kumar.
` as A;
then the output is show fine. but if the comma is not there in then the
last column data showing blank.
Is this a bug ??
..
Thanks & Regards
*Sanjiv Kumar*
Data showing null. What is the problem. Is this a bug.??
My Output is:- class column showing blank.
--
..
Thanks & Regards
*Sanjiv Kumar*
executing this query:- select * from demoplugin.dbo.category limit 5;
Even this query also take 1 hour to show output.
Please tell some solution for that.
--
Thanks & Regards.
Sanjiv Kumar.
It will work. Check out this link..
https://technologyredirect.blogspot.in/2016/09/how-to-run-apache-drill-programatically.html
Hello
I am using Drill in Window 10 in embedded mode having latest version
(1.7).
I am writing one select Query for Sql Server Database.
Query is:-
SELECT CAST(T1.`ID` AS BIGINT) AS `ID`, CAST(T1.`AttributeID` AS BIGINT) AS
`AttributeID`, T1.`String_Value` AS `String_Value`,
Hello
I am running Apache Drill in following version:-
Drill Version - 1.7
OS - Window 8.1
I am running drill in embedded mode.
I am trying to configure user authentication in Drill.
I am referring :
https://drill.apache.org/docs/configuring-user-authentication/
I copies libpam.so at
How drill runs query internally. I want to know how drill execute query for
different data sources.I want to know internal process of drill.
..
Thanks & Regards
*Sanjiv Kumar*
ay to call that function(doEnable())?
..
Thanks & Regards
*Sanjiv Kumar*
nable('StoragePlugin Name",
true) [function].
I want to know how to call doEnable() [function()], programatically for
enabling or disabling storage plugin.??
..
Thanks & Regards
*Sanjiv Kumar*
Is it possible to enable or disable multiple storage plugins at a time
through web console.
OR Is there any other specific way to do so. ??
--
..
Thanks & Regards
*Sanjiv Kumar*
I have tables :
Sl No
Name
Status
Time Taken
1
Description
In Progress
2
2
StockNumber
In Progress
3
3
SpecSheet
Completed
3
I want to display all the row of NAME column(i.e:- Description.
StockNumber, SpecSheet) as Column name in SQL SERVER using Drill.
EXAMPLE:-
Description
DIFFERENT DATATYPE TO BOTH
THE TABLE, OUTPUT COMING FINE.
*Is it possible to join two table using same storage plugin name? If
yes,then What am I doing wrong in this query?*
..
Thanks & Regards
*Sanjiv Kumar*
Then, how to convert row data to column using Apache Drill ?
..
Thanks & Regards
Does Apache Drill Supports Sql Pivot.
I have this:-
SQL QUERY for Creating TABLE is:-
`create table Attribute (ID int ,Name varchar(250))`.
INSERT QUERY is:-
`insert into Attribute values(1, 'Description'),
(2, 'StockNumber'),
Hello
Would you please tell me when Apache Drill 1.7 Version will going to
release?.
..
Thanks & Regards
Sanjiv Kumar
Hello
I want to know that what are the required classes and jar files for
compiling java file in window environment for custom authentiaction. OR
How I will create Custom Authentication in Window.
..
Thanks & Regards
*Sanjiv Kumar*
his time i get some proper solution from Drill.
..
Thanks & Regards
*Sanjiv Kumar*
--
..
Thanks & Regards
*Sanjiv Kumar*
his time i get some proper solution from Drill.
..
Thanks & Regards
*Sanjiv Kumar*
Hello
I have posted my problem, but didn't get any reply from Drill. I
have also posted my problem with example as asked. Please tell me its a bug
or i am doing anything wrong in it. If its a bug when drill community going
to solve this problem.
..
Thanks & Regards
Hello Magnus Pierre,
Thanks for reply.Would you please write some custom
authenticator
for window.
..
Thanks & Regards
*Sanjiv Kumar*
session_max_idle_secs: 3600
},
Now My Web console is not opening. I want to know that, how can i access
web console now ( by enabling ssl_enabled: true)?
Where to provide username & password to access web console in authenticate
mode?
..
Thanks & Regards
*Sanjiv Kumar*
Hello
I have posted my problem which i am facing in join query.
AS SUBJECT:- Multiple Column having same name & same data type problem
You have replied for that question and asked to send output, I had posted
output as well.
AS SUBJECT :- RE:Multiple Column having same name & same data
*I am explaining my problem which i have posted earlier:-*
I am posting the output which i am getting after executing join query.
*My query is:-*
*select Reports.ID, Reports.Name, ReportSetting.ID as RP_ID,
ReportSetting.Name as RP_Name from MySql.test_mopslive.reports as Reports
join
*I am explaining my problem which i have posted earlier:-*
I am posting the output which i am getting after executing join query.
*My query is:-*
*select Reports.ID, Reports.Name, ReportSetting.ID as RP_ID,
ReportSetting.Name as RP_Name from MySql.test_mopslive.reports as Reports
join
Hello
I am facing problem in executing join query. My Scenario is :-
I am having two tables and I am joining those tables in a join query with
same storage plugin. Those two tables has column with same name and same
datatype (ID int). And I am selecting both the ID columns from both tables.
Hello
I am new in Apache Drill.I am running drill in embedded mode with
window 8.1 operating system.
My question is how to authenticate drill. I want if any one start
drill, it will ask for user name and password to start drill. I know that
drill use PAM Authentication. But I don't
Please tell me when or in which updated version of Apache Drill, you are
going to give storage plugin for query Excel (.xsl) and Ms Access File
(.accdb).
g).*
*My CORE Query:*
*select * from SqlServer.core.Users;(Its not working).*
*NOTE: SqlServer is Storage Plugin Name.*
*My Question is whether Drill Supports only dbo schema or all schemas in
DB ?*
because, while firing show databases; query. User created schema is no
showing(e.g: core, P21, output, etc schemas).
--
Thanks & Regards.
Sanjiv Kumar
Is it possible to access files from other systems in apache drill? If yes
then how?
Hello
I want to know how to query from excel file(.xslx) and ms access
file using drill.
--
Thanks & Regards
* Sanjiv Kumar*
Hello
Would you please tell me (examples) how to show data from sql
server using apache drill in c# programming.
If possible please give some example or demo.
Thanks in Advance.
--
Thanks & Regards
* Sanjiv Kumar*
63 matches
Mail list logo