You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "vipin (JIRA)" <ji...@apache.org> on 2016/12/16 17:30:58 UTC
[jira] [Created] (DRILL-5133) Drill Doesn't Support Parameter
passing to a SQL query passed through pyodbc.
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)