MeridianMERIDIAN

component

4 component types: none a sibling also accepts.

4 types

The 4 component types

Each type's first registry sample, against every sibling's rule

TypeSampleAlso accepted by
Day of Week Name
day_of_week · VARCHAR
Monday—
Full Month Name
month_name · VARCHAR
January—
Periodicity
periodicity · VARCHAR
Daily—
Calendar Year
year · SMALLINT
2024—

Which component type is it?

No component type's rule accepts it.

Day of Week Name, Full Month Name and Periodicity carry no pattern or format, so they have no rule to ask.

Use it

CLI · DuckDB
$ printf '%s\n' 'Monday' 'Friday' > column.txt
$ finetype infer -f column.txt --mode column

SELECT ft_profile(v) FROM (VALUES ('Monday'), ('Friday')) t(v);

No component type's rule accepts Friday.

Type Registry