drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "vipin (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-5133) Drill Doesn't Support Parameter passing to a SQL query passed through pyodbc.
Date Fri, 16 Dec 2016 17:30:58 GMT
vipin created DRILL-5133:
----------------------------

             Summary: Drill Doesn't Support Parameter passing to a SQL query passed through
pyodbc. 
                 Key: DRILL-5133
                 URL: https://issues.apache.org/jira/browse/DRILL-5133
             Project: Apache Drill
          Issue Type: Bug
          Components: Functions - Drill
    Affects Versions: 1.9.0
         Environment: Drill with Python
            Reporter: vipin


import pyodbc
from pandas import *
 
# initialize the connection
conn = pyodbc.connect("DSN=S3-Vipin", autocommit=True)
cursor = conn.cursor()
network= input("enter network")
# setup the query and run it
s = "SELECT count(*)  FROM `dfs`.`tmp`.`ad_schedule` where network_no =%s" 
# fetch and display filtered output
cursor.execute(s,(network))
b = Series(cursor.fetchall())
print (b)



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message