---
warning: DO NOT CHANGE THIS MANUALLY, THIS IS GENERATED BY https://github/duckdb/community-extensions repository, check README there
title: httpd_log
excerpt: |
  DuckDB Community Extensions
  Reads and parses Apache HTTP server log files

extension:
  name: httpd_log
  description: Reads and parses Apache HTTP server log files
  version: 0.1.0
  language: C++
  build: cmake
  license: MIT
  maintainers:
    - saygox

repo:
  github: saygox/duckdb-httpd-log
  ref: f5aad68f1050a5290ae5c69166c182e5d9d59a09

docs:
  hello_world: |
    -- Basic usage (format auto-detected)
    SELECT * FROM read_httpd_log('access.log');

    -- Read from S3 (requires httpfs extension)
    LOAD httpfs;
    SELECT * FROM read_httpd_log('s3://bucket/logs/*.log.gz');

    -- Auto-select format from httpd.conf
    SELECT * FROM read_httpd_log('access.log', conf='/etc/httpd/conf/httpd.conf');

    -- Specify format from httpd.conf
    SELECT * FROM read_httpd_log('access.log', conf='httpd.conf', format_type='combined')

    -- Read with custom format string
    SELECT * FROM read_httpd_log('access.log',
        format_str='%h %l %u %t "%r" %>s %b %D');

  extended_description: |
    - Common Log Format and Combined Log Format (auto-detected)
    - Glob patterns, S3, gzip, and other sources via DuckDB's filesystem layer
    - Automatic format selection from httpd.conf
    - Parsed and normalized data (timestamps converted to UTC, request lines decomposed)
    - Custom formats via Apache LogFormat syntax
    - Dynamic schema generation with automatic column collision resolution

extension_star_count: 0
extension_star_count_pretty: 0
extension_download_count: 587
extension_download_count_pretty: 587
image: '/images/community_extensions/social_preview/preview_community_extension_httpd_log.png'
layout: community_extension_doc
---

### Installing and Loading
```sql
INSTALL {{ page.extension.name }} FROM community;
LOAD {{ page.extension.name }};
```

{% if page.docs.hello_world %}
### Example
```sql
{{ page.docs.hello_world }}```
{% endif %}

{% if page.docs.extended_description %}
### About {{ page.extension.name }}
{{ page.docs.extended_description }}
{% endif %}

### Added Functions

<div class="extension_functions_table"></div>

|  function_name  | function_type | description | comment | examples |
|-----------------|---------------|-------------|---------|----------|
| read_httpd_conf | table         | NULL        | NULL    |          |
| read_httpd_log  | table         | NULL        | NULL    |          |