{"action":"created","issue":{"url":"https://api.github.com/repos/apache/incubator-doris/issues/2242","repository_url":"https://api.github.com/repos/apache/incubator-doris","labels_url":"https://api.github.com/repos/apache/incubator-doris/issues/2242/labels{/name}","comments_url":"https://api.github.com/repos/apache/incubator-doris/issues/2242/comments","events_url":"https://api.github.com/repos/apache/incubator-doris/issues/2242/events","html_url":"https://github.com/apache/incubator-doris/issues/2242","id":525007087,"node_id":"MDU6SXNzdWU1MjUwMDcwODc=","number":2242,"title":"Is that will be better create table with column default enable to be null?","user":{"login":"caiconghui","id":55968745,"node_id":"MDQ6VXNlcjU1OTY4NzQ1","avatar_url":"https://avatars3.githubusercontent.com/u/55968745?v=4","gravatar_id":"","url":"https://api.github.com/users/caiconghui","html_url":"https://github.com/caiconghui","followers_url":"https://api.github.com/users/caiconghui/followers","following_url":"https://api.github.com/users/caiconghui/following{/other_user}","gists_url":"https://api.github.com/users/caiconghui/gists{/gist_id}","starred_url":"https://api.github.com/users/caiconghui/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/caiconghui/subscriptions","organizations_url":"https://api.github.com/users/caiconghui/orgs","repos_url":"https://api.github.com/users/caiconghui/repos","events_url":"https://api.github.com/users/caiconghui/events{/privacy}","received_events_url":"https://api.github.com/users/caiconghui/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":6,"created_at":"2019-11-19T13:24:00Z","updated_at":"2019-11-21T07:24:04Z","closed_at":null,"author_association":"CONTRIBUTOR","body":"on production enviroment, create table usually with so many nullable columns, i think except key column, other column can be nullable for default? or not nullable column for default is for special purpose? "},"comment":{"url":"https://api.github.com/repos/apache/incubator-doris/issues/comments/556955387","html_url":"https://github.com/apache/incubator-doris/issues/2242#issuecomment-556955387","issue_url":"https://api.github.com/repos/apache/incubator-doris/issues/2242","id":556955387,"node_id":"MDEyOklzc3VlQ29tbWVudDU1Njk1NTM4Nw==","user":{"login":"caiconghui","id":55968745,"node_id":"MDQ6VXNlcjU1OTY4NzQ1","avatar_url":"https://avatars3.githubusercontent.com/u/55968745?v=4","gravatar_id":"","url":"https://api.github.com/users/caiconghui","html_url":"https://github.com/caiconghui","followers_url":"https://api.github.com/users/caiconghui/followers","following_url":"https://api.github.com/users/caiconghui/following{/other_user}","gists_url":"https://api.github.com/users/caiconghui/gists{/gist_id}","starred_url":"https://api.github.com/users/caiconghui/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/caiconghui/subscriptions","organizations_url":"https://api.github.com/users/caiconghui/orgs","repos_url":"https://api.github.com/users/caiconghui/repos","events_url":"https://api.github.com/users/caiconghui/events{/privacy}","received_events_url":"https://api.github.com/users/caiconghui/received_events","type":"User","site_admin":false},"created_at":"2019-11-21T07:24:03Z","updated_at":"2019-11-21T07:24:03Z","author_association":"CONTRIBUTOR","body":"Maybe default nullable column may confuse users except hadoop users. In many database system, such as kudu, hive, mysql, the default nullable column is a common use case, we get data from hdfs, kafka, which cannot ensure that column data not null, actually, null value for many columns  is very common in production enviroment. And kudu, parquet, orc file also process with nullable column well. It is also ok for us to mark every non key column nullable explicitly if column not nullable default feature is so much important for doris on scan performance. But the specail design should be noted in the document, because normal users may not think too much when create table, and may load data failed because of data not allowed null default. "}}
{"actor":{"display_login":"caiconghui"}}