You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hop.apache.org by "gertwieland (via GitHub)" <gi...@apache.org> on 2023/03/21 14:35:43 UTC

[GitHub] [hop] gertwieland opened a new issue, #2756: [Feature Request]: Allow users to define default data types

gertwieland opened a new issue, #2756:
URL: https://github.com/apache/hop/issues/2756

   ### What would you like to happen?
   
   The "Insert / Update" transform automatically generates SQL code to create a target table in case it does not exist.
   For strings, it uses the data type "varchar" as default.
   In my case, I always use "nvarchar". Currently, the only way to achieve this is by performing a text replacement in an external editor.
   
   I think it would be great if there were a setting that would allow users to define the default type.
   
   Maybe a simple solution could be a mapping table like this
   
   DefaultType   ReplaceWith
   nvarchar         nvarchar
   
   The fields should probably be pulldowns that simply list all available data types, i.e. all those that are being used by Hop.
   I know this could lead to nonsensical selections (like replace varchar with boolean), but I would argue that this is the user's respsonsibility.
   
   This is [in relation to this conversation on Mattermost.](https://chat.project-hop.org/hop/pl/q7nd6pf9yfgcdpypbc3ypbwowc)
   
   ### Issue Priority
   
   Priority: 3
   
   ### Issue Component
   
   Component: Hop Gui


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: issues-unsubscribe@hop.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

Re: [I] [Feature Request]: Allow users to define default data types (hop)

Posted by "mattcasters (via GitHub)" <gi...@apache.org>.
mattcasters commented on issue #2756:
URL: https://github.com/apache/hop/issues/2756#issuecomment-5341305462

   Implemented over here: https://github.com/mattcasters/hop-data-vault/issues/127
   Candidate for porting over to apache/hop


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: issues-unsubscribe@hop.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

Re: [I] [Feature Request]: Allow users to define default data types (hop)

Posted by "mattcasters (via GitHub)" <gi...@apache.org>.
mattcasters commented on issue #2756:
URL: https://github.com/apache/hop/issues/2756#issuecomment-1813339564

   I proposed the introduction of a new "DDL" metadata type (#2781) so perhaps we need some DDL Settings to go along with that.  We could steer data types in a certain direction as post-processors for what essentially is recommended by the JDBC drivers.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: issues-unsubscribe@hop.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org