[HOP-4553] Table input: <null> returned from query against SQL server with GETDATE() function

• Type: Bug
• Status: Closed
• Priority: Normal
• Resolution: Abandoned
• Affects Version/s: 2.1.0
• Fix Version/s: Not applicable
• Component/s: Pipelines
• Labels: newbie
• Environment: Hop Version: 2.1.0 ; JDBC: sqljdbc_10.2.1.0 ; Windows Server 2016 Standard (German)
• Assignee: Unassigned
• Reporter: Stefan Illwitzer
• Created: 04/Nov/22 17:59
• Updated: 09/Feb/23 14:06
• Resolved: 09/Feb/23 14:06

Description

Hi,

this query works fine in SQL Server Management Studio
 
SELECT 
GETDATE() dtTimestamp,
cSellerSKU, kUser, nQuantity, cConditionType, cWarehouseConditionType, nQtyWarehouse, nQtyUnsellable, nQtyReserved, nQtyTotal, nQtyInboundWorking, nQtyInboundShipped, nQtyReceiving, fVolume, cFNSKU, cMarketplaceId, cRegion, nPlattform
FROM dbo.pf_amazon_angebot_fba; 
 
But in Hop / Table input I only get <null> returned in column dtTimestamp (in Examine preview data and later on).

See screeshot below.

Is this a bug or wrong use?

Thanks and regards
Stefan