[MCOL-1308] Guess functionality doesn't work as expected in some cases Created: 2018-03-27  Updated: 2023-10-26  Resolved: 2022-11-05

Status: Closed
Project: MariaDB ColumnStore
Component/s: None
Affects Version/s: 1.1.4
Fix Version/s: Icebox

Type: Bug Priority: Minor
Reporter: Elena Kotsinova (Inactive) Assignee: Unassigned
Resolution: Won't Do Votes: 0
Labels: usability

Attachments: JPEG File guess_func.JPG    

 Description   

Guessing functionality is accessible when user wants to map fields from input module to fields in database table.
The functionality is available at the following location in the UI:
Open MariaDB Bulk Loader module > Field mapping tab > Custom mapping button window > Guess button

The following issues detected during testing:

1. If all fields, came from input module, have different names Guess functionality doesn't work even if database fields are the same number. User must map every field one by one which can be hard for tables with many columns. Expected for this case is that guess functionality will map fields according their appearance in the list. I.e. first field from input to the first field in the table. This will speed up the process a lot.

2. Only one field from input has different name.
User clicks Map all inputs button and all fields except one are mapped correctly.
User opens the Custom mapping and clicks Guess button there.
This action adds one of already automatically mapped fields. In my case this is the first field in the list. See the screenshot for situation after clicking the button several times. It is expected that if there is only one field left and user clicks guess button this field must be mapped.



 Comments   
Comment by Jens Röwekamp (Inactive) [ 2018-03-27 ]

It's a general bug in Pentaho's guessing behaviour and not specific to our plugin.

To fix it we could either report the bug to Pentaho and hope they fix it for us or clone EnterMappingDialog.java and adjust it for our purposes.

If we choose the clone option we might run into compatibility issues once Pentaho decides to change the API for EnterMappingDialog.java.

Therefore, I would suggest to report it to Pentaho and close this issue.

Comment by Todd Stoffel (Inactive) [ 2022-11-05 ]

This item is being closed because it was well passed the expiration date with no activity. If you suspect this was done in error please create a new ticket.

Generated at Thu Feb 08 02:27:46 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.