*I am explaining my problem which i have posted earlier:-*
I am posting the output which i am getting after executing join query.
*My query is:-*
*select Reports.ID, Reports.Name, ReportSetting.ID as RP_ID,
ReportSetting.Name as RP_Name from MySql.test_mopslive.reports as Reports
join MySql.test_mopslive.reportsetting as ReportSetting on Reports.ID =
ReportSetting.ID*
ID
Name
RP_ID
RP_Name
30
My_Naveen
null
null
31
My_Sanjiv
null
null
32
My_Sreekant
null
null
*EXPECTED O/P:*
ID
Name
RP_ID
RP_Name
30
My_Naveen
30
My_Naveen
31
My_Sanjiv
31 My_Sanjiv
32
My_Sreekant
32 My_Sreekant
I am trying with this example also.it works fine.
*QUERY AFTER CASTING:-*
*select Reports.ID, Reports.Name, cast(ReportSetting.ID as int),
cast(ReportSetting.Name as varchar(25)) from MySql.test_mopslive.reports as
Reports join*
* MySql.test_mopslive.reportsetting as ReportSetting on Reports.ID =
ReportSetting.ID.*
I know its not a proper solution. I think its a bug. So Please suggest some
appropriate solution for that.
*SCENARIO:->*
*1*) When two column having same name and different data type:- Its
Showing memory leak error.:
*ERROR:-*
org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR:
IllegalStateException: Memory was leaked by query. Memory leaked: (40960)
Allocator(op:0:0:3:JdbcSubScan) 1000000/40960/311296/10000000000
(res/actual/peak/limit) Fragment 0:0
2) When two column having different column name and same data type, its
working fine.
3) When two column having same name and same datatype, then its not working.
