Sql error

Former Member — Sun, 16 Jun 2019 06:53:45 GMT

How can I convert this query to sql sap Hana?

select txn_year,txn_month, sum(transaction_volume) as transaction_volume from (select year(from_unixtime(t.timestamp/1000)) as txn_year,MONTHNAME(from_unixtime(t.timestamp/1000)) as txn_month, count(t.id) transaction_volume from type_4 t

where t.assetId="EvN8cvuGKC2t1PA8ZEsgJth3paenSP4UAd8Z6K14z2P4" GROUP BY txn_month,txn_year union select year(from_unixtime(t.timestamp/1000)) as txn_year,MONTHNAME(from_unixtime(t.timestamp/1000)) as txn_month, count(t.id) transaction_volume from type_11 t
where t.assetId="EvN8cvuGKC2t1PA8ZEsgJth3paenSP4UAd8Z6K14z2P4" GROUP BY txn_month,txn_year ) sd GROUP BY txn_month,txn_year ORDER BY FIELD(txn_month,'January','February','March','April','May','June','July','August','September','October','November','December');

Re: Sql error

Former Member — Mon, 17 Jun 2019 00:59:44 GMT

Hi jass kopov

Have you tried this tool - https://github.com/B1SA/HanaTranslator-Src to convert your query to SQL SAP Hana format?

Regards,

Sam

topic Re: Sql error in Application Development and Automation Discussions

Sql error

Re: Sql error