[ZEPPELIN-3625] Pandasql interpreter fails to query over python interpreter dataframe

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.8.0, 0.9.0
• Fix Version/s: 0.8.1, 0.9.0
• Component/s: Interpreters
• Assignee: Khalid Huseynov
• Reporter: Khalid Huseynov
• Created: 15/Jul/18 08:44
• Updated: 23/Jan/19 02:47
• Resolved: 19/Jul/18 23:02

Description

run below paragraphs to reproduce

%python

import pandas as pd
import numpy as np
df = pd.DataFrame(
np.array([
np.arange(0, 200),
np.random.randn(200).cumsum(),
np.random.randn(200).cumsum(),
np.random.randint(1, 3, 200)
]).transpose(),
columns=["X", "Y", "Z", "Group"])

z.show(df)

%python.sql
select * from df

Note that master and branch 0.8 both fail to query but errors in each case are different

Issue Links

• is related to: ZEPPELIN-3629 Release 0.8.1
• links to: GitHub Pull Request #3071
• links to: GitHub Pull Request #3073