sqllineage icon indicating copy to clipboard operation
sqllineage copied to clipboard

Published 20 hours ago • verified publisher icon reata

Update sqlalchemy.py

Open zhengtingxue opened this issue 10 months ago • 2 comments

add support get field list from hive metastore mysql database

zhengtingxue avatar Apr 24 '24 07:04 zhengtingxue

add support get field list from hive metastore mysql database

zhengtingxue avatar Apr 24 '24 07:04 zhengtingxue

Hello. I would like to know what is the purpose of this pull?

Based on typical scenarios, I have a few questions: insert into target_table partition(month_id='202301',day_id='22') select *** from source_tab

  1. Should the collected field list be stored in field order? I understand that field order is necessary for subsequent use of the metadata. When column information of target_table is required, the field order determines the mapping relationship of source_table columns.

  2. Is it necessary to eliminate or distinguish whether the field is a partition field? The partition field should not be used as a column in the target_table or at least needs to be distinguished

  3. It is recommended to use f-string writing method for string instead of splicing

delphisharp avatar Apr 26 '24 06:04 delphisharp

Thank you for your reply. I realize that I have not considered enough, and my thoughts were too simplistic.

zhengtingxue avatar Apr 30 '24 06:04 zhengtingxue