[jira] [Created] (DRILL-4516) Transform SUM(1) query to COUNT(1)
Sudip Mukherjee created DRILL-4516: -- Summary: Transform SUM(1) query to COUNT(1) Key: DRILL-4516 URL: https://issues.apache.org/jira/browse/DRILL-4516 Project: Apache Drill Issue Type: Improvement Components: Query Planning & Optimization Reporter: Sudip Mukherjee If we connect drill with tableau we see some query requests like , select sum(1) tablename. This results in pulling all the records out of the underlying datasource and aggregate them to get row count. The behavior can be optimized if the query gets transformed into a count(1) query which is likely to be optimized at the datasource level -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Created] (DRILL-4880) Support JDBC driver registration using ServiceLoader
Sudip Mukherjee created DRILL-4880: -- Summary: Support JDBC driver registration using ServiceLoader Key: DRILL-4880 URL: https://issues.apache.org/jira/browse/DRILL-4880 Project: Apache Drill Issue Type: Bug Components: Client - JDBC Affects Versions: 1.8.0 Environment: Windows Server 2012 Reporter: Sudip Mukherjee Fix For: 1.9.0 Currently drill-jdbc-all*.jar doesn't contain a META_INF/services/java.sql.Driver file which is apparently used to discover a service by Java ServiceLoader API. Can drill jdbc driver have this file like all the other jdbc drivers so that the driver can be loaded using ServiceLoader instead of a direct Class.forName? -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Created] (DRILL-3528) Apache drill plugin for solr
Sudip Mukherjee created DRILL-3528: -- Summary: Apache drill plugin for solr Key: DRILL-3528 URL: https://issues.apache.org/jira/browse/DRILL-3528 Project: Apache Drill Issue Type: New Feature Components: Storage - Other Environment: windows, eclipse ide Reporter: Sudip Mukherjee Assignee: Jacques Nadeau I am trying to explore apache drill project and able to set it in my local enviroment with the help of documentation. However, i was looking for some code flow document to get started with writing a custom plug-in for trial. I am trying add a type of apache solr to have a sql like interface on top of it. when i added the project plugin under /jars folder and tried to create new storage of type solr got an exception "Error : Invalid JSON mapping". Could you please help me with some debugging points. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Resolved] (DRILL-3528) Apache drill plugin for solr
[ https://issues.apache.org/jira/browse/DRILL-3528?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sudip Mukherjee resolved DRILL-3528. Resolution: Fixed > Apache drill plugin for solr > > > Key: DRILL-3528 > URL: https://issues.apache.org/jira/browse/DRILL-3528 > Project: Apache Drill > Issue Type: New Feature > Components: Storage - Other > Environment: windows, eclipse ide,java 8 ,maven 3x >Reporter: Sudip Mukherjee >Assignee: Jacques Nadeau > Attachments: storage-solr.rar > > > I am trying to explore apache drill project and able to set it in my local > enviroment with the help of documentation. However, i was looking for some > code flow document to get started with writing a custom plug-in for trial. I > am trying add a type of apache solr to have a sql like interface on top of > it. > when i added the project plugin under /jars folder and tried to create new > storage of type solr got an exception "Error : Invalid JSON mapping". > Could you please help me with some debugging points. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Created] (DRILL-3585) Apache Solr as a storage plugin
Sudip Mukherjee created DRILL-3585: -- Summary: Apache Solr as a storage plugin Key: DRILL-3585 URL: https://issues.apache.org/jira/browse/DRILL-3585 Project: Apache Drill Issue Type: New Feature Components: Client - HTTP Reporter: Sudip Mukherjee Assignee: Jason Altekruse A new storage plugin supporting Apache solr search engine. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Created] (DRILL-4172) Need stop , port as startup parameters in case drill is installed as windows service
Sudip Mukherjee created DRILL-4172: -- Summary: Need stop , port as startup parameters in case drill is installed as windows service Key: DRILL-4172 URL: https://issues.apache.org/jira/browse/DRILL-4172 Project: Apache Drill Issue Type: Bug Affects Versions: 1.3.0 Environment: Windows Reporter: Sudip Mukherjee Fix For: Future I am trying to install Drill using procrun in windows server for persistent service other than running batch file. I was in need of start , stop and port parameter for the flexibility to start/stop the service from windows services.msc Does it make sense to introduce these as startup params ( optional )? -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Created] (DRILL-4294) InfoSchema is not returning column metadata if the query contains escape character
Sudip Mukherjee created DRILL-4294: -- Summary: InfoSchema is not returning column metadata if the query contains escape character Key: DRILL-4294 URL: https://issues.apache.org/jira/browse/DRILL-4294 Project: Apache Drill Issue Type: Bug Affects Versions: Future, 1.4.0 Reporter: Sudip Mukherjee Below Query returns noting where escape character is "\\": SELECT TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, CASE DATA_TYPE WHEN 'ANY', 'MAP' THEN 'CHARACTER VARYING' ELSE DATA_TYPE END as DATA_TYPE, CASE DATA_TYPE WHEN 'ANY', 'MAP' THEN 'CHARACTER VARYING' ELSE DATA_TYPE END as DATA_TYPE_NAME, CASE DATA_TYPE WHEN 'BINARY' THEN CHARACTER_MAXIMUM_LENGTH WHEN 'CHARACTER VARYING' THEN CHARACTER_MAXIMUM_LENGTH WHEN 'CHARACTER' THEN CHARACTER_MAXIMUM_LENGTH WHEN 'DATE' THEN DATETIME_PRECISION WHEN 'INTERVAL' THEN INTERVAL_PRECISION WHEN 'VARCHAR' THEN CHARACTER_MAXIMUM_LENGTH WHEN 'VARBINARY' THEN CHARACTER_MAXIMUM_LENGTH ELSE NUMERIC_PRECISION END as COLUMN_SIZE, NUMERIC_SCALE as DECIMAL_DIGITS, CASE DATA_TYPE WHEN 'CHARACTER VARYING' THEN CHARACTER_MAXIMUM_LENGTH WHEN 'CHARACTER' THEN CHARACTER_MAXIMUM_LENGTH WHEN 'VARCHAR' THEN CHARACTER_MAXIMUM_LENGTH ELSE 9 END as BUFFER_LENGTH, NUMERIC_PRECISION_RADIX, IS_NULLABLE as NULLABLE, 12 as REMARKS, 13 as COLUMN_DEF, 14 as SQL_DATA_TYPE, 15 as SQL_DATETIME_SUB, CHARACTER_MAXIMUM_LENGTH as CHAR_OCTET_LENGTH, ORDINAL_POSITION, IS_NULLABLE, 18 as USER_DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_CATALOG LIKE 'DRILL' ESCAPE '\' AND TABLE_SCHEMA LIKE 'dfs.tmp' ESCAPE '\' AND TABLE_NAME LIKE 'app\_client\_view' ESCAPE '\' ORDER BY TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, ORDINAL_POSITION, COLUMN_NAME -- This message was sent by Atlassian JIRA (v6.3.4#6332)