[jira] [Created] (DRILL-5133) Drill Doesn't Support Parameter passing to a SQL query passed through pyodbc.

["vipin (JIRA)" <ji...@apache.org>]

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)