This message was deleted.

Yes.

@Abhishek Agarwal I'm looking for any Druid native query or API to get the same?

you can run queries against information_schema.

Something like this:

curl  -X 'POST' -H 'Content-Type:application/json' -d '{"query":"SELECT COLUMN_NAME, DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = '\''druid'\'' AND TABLE_NAME = '\''wikipedia'\''"}' <http://localhost:8888/druid/v2/sql>

will return

[{"COLUMN_NAME":"__time","DATA_TYPE":"TIMESTAMP"},{"COLUMN_NAME":"isRobot","DATA_TYPE":"VARCHAR"},{"COLUMN_NAME":"channel","DATA_TYPE":"VARCHAR"},{"COLUMN_NAME":"flags","DATA_TYPE":"VARCHAR"},{"COLUMN_NAME":"isUnpatrolled","DATA_TYPE":"VARCHAR"},{"COLUMN_NAME":"page","DATA_TYPE":"VARCHAR"},{"COLUMN_NAME":"diffUrl","DATA_TYPE":"VARCHAR"},{"COLUMN_NAME":"added","DATA_TYPE":"BIGINT"},{"COLUMN_NAME":"comment","DATA_TYPE":"VARCHAR"},{"COLUMN_NAME":"commentLength","DATA_TYPE":"BIGINT"},{"COLUMN_NAME":"isNew","DATA_TYPE":"VARCHAR"},{"COLUMN_NAME":"isMinor","DATA_TYPE":"VARCHAR"},{"COLUMN_NAME":"delta","DATA_TYPE":"BIGINT"},{"COLUMN_NAME":"isAnonymous","DATA_TYPE":"VARCHAR"},{"COLUMN_NAME":"user","DATA_TYPE":"VARCHAR"},{"COLUMN_NAME":"deltaBucket","DATA_TYPE":"BIGINT"},{"COLUMN_NAME":"deleted","DATA_TYPE":"BIGINT"},{"COLUMN_NAME":"namespace","DATA_TYPE":"VARCHAR"},{"COLUMN_NAME":"cityName","DATA_TYPE":"VARCHAR"},{"COLUMN_NAME":"countryName","DATA_TYPE":"VARCHAR"},{"COLUMN_NAME":"regionIsoCode","DATA_TYPE":"VARCHAR"},{"COLUMN_NAME":"metroCode","DATA_TYPE":"VARCHAR"},{"COLUMN_NAME":"countryIsoCode","DATA_TYPE":"VARCHAR"},{"COLUMN_NAME":"regionName","DATA_TYPE":"VARCHAR"}]

@Kyle Hoondert Thanks, so is this metadata which we get after execution of the query which you have provided gives all columns from all segments, Like if let's say column

someColumn

present in segment1 but not present in segment2, So still this query will give the data of

someColumn

?

afaik, yes, schema is inferred from all the segments, to make it flexible. However, I think some work was or is being done to make it possible to have a fixed, declared schema. I'm not sure where it's at though.